Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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?

13 REPLIES 13
Jords
Frequent Visitor
Adamboer
Responsive Resident
Responsive Resident

In your scenario, as you have already noticed, there isn't a direct endpoint to export a dataset programmatically. One possible workaround could be to create a new report with just one visual using the dataset "My Data" and then export that report programmatically using the Export Report In Group endpoint.

Another alternative could be to use the Get Data Source API endpoint to get the connection information for the dataset and then use that information to programmatically connect to the dataset and export the data.

Please let me know if this helps, or if you have any further questions.

Thanks for these suggestions I will definitely investigate them. 

For you second suggestion you say to programatically connect to the dataset and export the data; do you mean by directly connecting to the underlying source of data (i.e. SQL Server) and then pull the data from the tables?

James4336
Regular Visitor

Need this too.  The interal API is obviously there as you can do it from the interface, it just needs exposing into the public API.  Shouldn't be a difficult or time consuming job.

jcalheir
Solution Supplier
Solution Supplier

Need this as well

powerbi_jenhen
Resolver II
Resolver II

I need this also

Anonymous
Not applicable

I also have this need +1

Anonymous
Not applicable

We also really need this feature. We are using the APIs to migrate from tenant to another and we have a lot of datasets used by paginated reports but that have no associated power bi report.

Anonymous
Not applicable

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?

Anonymous
Not applicable

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.