cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Download entire dataset behind the report\dashboard

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?

5 REPLIES 5
Highlighted
Continued Contributor
Continued Contributor

Hi @srik

 

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. "

Greetings Hp Pfister
Power Query Buch online auf http://www.powerbi-pro.com
Highlighted

Hi @srikIt may depend on how the report was shared with them.  If @Pfister '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

Highlighted

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

Highlighted
Continued Contributor
Continued Contributor

@srik

 

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.

Greetings Hp Pfister
Power Query Buch online auf http://www.powerbi-pro.com
Highlighted

@srik,

@Pfister 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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors