Forum Discussion
Export to PDF/PowerPoint Not Respecting End-User Selections
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.
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
10 Replies
- Hi there
Are you trying to export the data?
If so you would always be an admin and see all the data.
Also if users are part of the App Workspace and have any other permission besides "Viewer" they too would be able to see all the data.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:
- Reset the report to default
- Filter using the new filtering experience
- Expand a row in a matrix using the + icon
- Export to PDF and/or PowerPoint
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.
