Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a report published in a Premium Capacity workspace with row-level security applied. Within the report is a matrix with 5 drillable row level dimensions. The report also uses the new filtering experience.
When exporting to PDF or PowerPoint (PPT) from the Power BI service, drill location and applied filters are not being respected. I have tested this in both Google Chrome and Internet Explorer, cleared the cache from both browers, and tried this with the new Power BI service look on and off.
Is there a known issue with exporting to PDF or PowerPoint? I looked for a setting in the Workspace, while publishing the app, and in the report itself within the app to see if I need to enable this behavior but have had no luck.
Solved! Go to Solution.
@GilbertQ The report I'm testing with was first created earlier this month and published to the Power BI service at the same time. I confirmed that I am on the newest version of Power BI Desktop and republished for testing again. Version: 2.73.5586.661 64-bit (September 2019)
It appears that other users are now having the same issue:
https://community.powerbi.com/t5/Issues/Powerpoint-will-not-Export-Current-Values/idi-p/795810
Hi @GilbertQ -
No, this is not related to exporting data. The row-level security is working as intended. I added that descroption to provide more context for my issue.
The issue is when exporting to PDF or PowerPoint (PPT) from the Power BI service, drill location and applied filters are not being respected. Below are the steps I'm following:
After following those steps, the filter I applied and the drill location are ignored in the screenshots visible in the PDF and PowerPoint (PPT) that are exported.
NIck
Hi there
Thanks for the clarification, I do think that this is a current limitation within the exporting options.
I do know that you can only currently export with filtered values as shown below.
@GilbertQ - I did use the Current Values option, with no luck. Even selecting Current Values, the export does not respect Filters, Drill Location, etc.
@GilbertQ The report I'm testing with was first created earlier this month and published to the Power BI service at the same time. I confirmed that I am on the newest version of Power BI Desktop and republished for testing again. Version: 2.73.5586.661 64-bit (September 2019)
It appears that other users are now having the same issue:
https://community.powerbi.com/t5/Issues/Powerpoint-will-not-Export-Current-Values/idi-p/795810
I am now having the same issue (I just started a new thread about it actually). But my exports are showing as if nothing was filtered (there were filters applied, and I used the correct "current values" export option).
I am nearly sure this used to work properly, but I don't export very much so I can't say exactly when it broke.
I guess I will open a support case about it.