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 (3)
RE: Exported Power BI excel sheet contains "no filter applied" text
Hi, has this been resolve or implement? We have the same issue which last row/line of the exported excel will display "No filters applied" or with "Applied filters: xxxxxxxxxxx". We need to impose a manual step to remove them.
RE: Exported Power BI excel sheet contains "no filter applied" text
We have similar situation when working with exports. If we need to do additional work on the data that last line has to be always removed. We have spoken with other teams and they have the same issue.
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.