As the administrator of our Power BI experience (and a newbie), there seems to be a confusing use case that I cannot get my head wrapped around.
When I pin dashboards and share them with others, I want them to have the ability to export the data to Excel or PowerPoint. This capability does not seem available to them, and I don't understand why.
When I am in the Desktop application, I have the ability to export - but for many of our users they will simple be consumers of dashboards only. There are no elipses in the "upper right" cornner of the tile????
In the desktop software, why can I only Export (to .csv) (see below screenshot)
How can I give our users the ability to export to PPT and/or Excel and/or .csv - from a dashboard view?
Any links, or specific steps/instructions would be much appreciated.
I am able to export data from a dashboard tile within a dashboard that is shared with me. Perhaps it has to do with the settings for the users in the workspace or at the tenant level. Have you gone to the admin portal to investigate the settings?
As for you last question, the ability to export to PPT or excel:
The service has the ability to export to PPT. If you go to the REPORT and not the dashboard, under "File" menu you will see it. It is a preview feature so if you don't see it, don't worry, you just need to turn on preview features under settings.
There is also the Analyze in Excel option, but this just creates a connection between a power pivot data model and the data model in the service. If you want to work with the raw data you need to export the csv.
However, with all that said, I will point out that PBI is a visualization tool, and the service is for collaboration. It is not meant to be a file sharing service. If you want users to be able to work with the data, I recommend using an R script in the query editor to write the data to a csv in a shared folder, that way you can let users work with the data separately from the PBI experience. Be cautious here though as this may lead to fragmented data marts and not "one version of the truth".
>>There are no elipses in the "upper right" cornner of the tile????
It seems like you use the "pin live page" function to pin these visuals to dashboard. If you use the "pin live page mode", these child tiles right-top option will be disabled. You can export the child tiles at report level.
Community Support Team _ Xiaoxin Sheng If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For learning resources/Release notes, please visit: | |