cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Export Power BI Dataset using API

Hi,

 

I'm trying to use the API to export a dataset which doesn't have a report associated with it.

 

My scenario:

  1. A .pbix file named "My Data.pbix" has been created in Power BI desktop containing data and deployed to the service
  2. This results in a dataset named "My Data" and a report also named "My Data" exising in the service
  3. Subsequent reports have been developed in Power BI Desktop connecting to the "My Data" dataset deployed to the service
  4. The "My Data" report generated in steps 1&2 has been deleted (the data set "My Data" remains)

 

Using the Export Report In Group endpoint I can export all reports from step 3 to local .pbix files, however I can't export the "My Data" dataset as there is no report explicitly associated with it. Neither can I find an endpoint for exporting datasets rather than reports.

 

I've read through the Duplicate workspaces using the Power BI REST APIs tutorial, but this doesn't seem to cover my scenario.

 

 

I can use a browser, navigate to the dataset and download from there, however I'm looking for a way to do this programmatically. Is this possible and if so how?

5 REPLIES 5
luuduong
Frequent Visitor

Adding my vote for this as well... is there a place we can vote for this feature to get built? Export dataset or run a query and export dataset?

sau001
Helper IV
Helper IV

Similar problem. Did you find any solution?

tpapp
New Member

Me too.

TBardien
Helper I
Helper I

Does anyone know if there is an answer to this yet?

sanderpolman
Regular Visitor

Need this too 🙂

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Kudoed Authors