Skip to main content
Microsoft Idea

Power BI

Needs Votes

Exported Power BI excel sheet contains "no filter applied" text

Vote (49) Share
SP Ramakrishnan's profile image

SP Ramakrishnan on 28 Feb 2020 08:21:28

When you try to export a power BI report into an excel sheet, you see an annoying first line that says "no filter applied" even though I didn't enable any filtering option while publishing the report. This requires an extra step for someone to manually delete the line which also prevents the process to be automated (eg if I want to save the file in a folder for a flow script to pickup and email to recipients). There should be either an option to disable this text or remove the line when the report doesn't contain any filters to choose.

Comments (1)
SP Ramakrishnan's profile image Profile Picture

Nicole Pia on 15 Sep 2023 18:47:22

RE: Exported Power BI excel sheet contains "no filter applied" text

I have created a dashboard within Teams for our divisions to download an Excel file and upload results into another system. We have to do an additional step of opening the file and deleting the last row " No filters applied" prior to uploading. Having the option to remove this row would greatly improve our process.