Download entire dataset behind the report\dashboard

[Anonymous]

Hello,

I have a report with 3 charts and a matrix and it all comes from one dataset. So one of the users want to download the detailed data, but the problem is there is no option to download all the data in the dataset. They have to click on each chart and then select export to excel. 

Is there way to download all the data available in that dataset?

[Anonymous]

I would like to download the dataset from power bi. Please let me know if the feature is enabled.

[Anonymous]

Hi @Anonymous

An user can download the dataset by exporting the pbix file from PBI Service,

if he has edit rights for the specific report and your administrator has not turned off the export data feature.

For more informations about this feature, please read

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-to-pbix/

Please be aware that:

"For now, the preview feature can only download reports that originated from Power BI Desktop. If your report originated from the Power BI service either via a cloud dataset or a content pack, we can't open it in Power BI Desktop yet. Stay tuned for updates in this area - we plan to extend this feature to other types of reports. "

[Anonymous]

I dont know if I'm confusing here. But I want to download the underlying detail\raw data in dataset.

[Anonymous]

@Anonymous

this is not possible at the moment.

You can download the data of a visual ("export to excel") or download the whole report with the data in a pbix file.

[mihart]

@Anonymous,

@Anonymous is correct.  Assuming the user has edit permissions to dataset, downloading the report as a .pbix file is the only way that I know of.  And then opening the .pbix in Desktop.

[mihart]

Hi @AnonymousIt may depend on how the report was shared with them.  If @Anonymous 's response didn't solve your problem, it may be because of how the report was shared. Can you supply more details? Which tool is the user using (Desktop, service), how was the report created, how did the user get the report - was it shared as a content pack, for example. If the user is in service can they open the dataset itself, or is only the report available to them?

- Michele