topic Re: Export Power BI Dataset using API in Developer

Export Power BI Dataset using API

Anonymous — Tue, 14 Jan 2020 17:06:03 GMT

Hi,

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

My scenario:

A .pbix file named "My Data.pbix" has been created in Power BI desktop containing data and deployed to the service
This results in a dataset named "My Data" and a report also named "My Data" exising in the service
Subsequent reports have been developed in Power BI Desktop connecting to the "My Data" dataset deployed to the service
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?

Re: Export Power BI Dataset using API

sanderpolman — Wed, 15 Jan 2020 14:29:30 GMT

Need this too 🙂

Re: Export Power BI Dataset using API

TBardien — Mon, 27 Jul 2020 07:49:13 GMT

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

Re: Export Power BI Dataset using API

tpapp — Sat, 20 Feb 2021 15:46:23 GMT

Me too.

Re: Export Power BI Dataset using API

Anonymous — Thu, 15 Apr 2021 21:56:41 GMT

Similar problem. Did you find any solution?

Re: Export Power BI Dataset using API

Anonymous — Wed, 02 Jun 2021 11:55:30 GMT

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?

Re: Export Power BI Dataset using API

Anonymous — Tue, 16 Nov 2021 15:15:35 GMT

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.

Re: Export Power BI Dataset using API

Anonymous — Sat, 12 Feb 2022 09:12:38 GMT

I also have this need +1

Re: Export Power BI Dataset using API

powerbi_jenhen — Wed, 01 Jun 2022 23:02:31 GMT

I need this also

Re: Export Power BI Dataset using API

Anonymous — Mon, 14 Nov 2022 16:38:48 GMT

Need this as well

Re: Export Power BI Dataset using API

James4336 — Wed, 15 Mar 2023 09:19:25 GMT

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.

Re: Export Power BI Dataset using API

Adamboer — Wed, 15 Mar 2023 12:59:02 GMT

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.

Re: Export Power BI Dataset using API

James4336 — Thu, 16 Mar 2023 08:57:31 GMT

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?

Re: Export Power BI Dataset using API

Anonymous — Mon, 04 Sep 2023 12:41:58 GMT

vote here
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=59634646-fb53-eb11-8fed-281878bd9103