Export/Read Data

[Anonymous]

Hello,

We have several reports on PowerBI.com, all this is running with the Office365 accounts from our company. (PBIPro).

Our Azure environment is still in POC mode and running with a special domain @...onmicrosoft.com

As security is very old fashionated a gateway is not allowed.

The Azure domain is even blocked from our normal network, we have to work by a second network (hotspot on wifi).

Is there a way to get the data with a c# program out of the PBI Dataset.

Would be a console app that extracts daily some KPI's and exports it into some old reporting databases.

I know, sounds a bit silly but some old applications will take over a year beofre they are reworked into Azure and PowerBI.

And first our Azure should get out of POC mode ....

But meanwhile ..

Kind regards

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

I don't think there is a direct way to get the data out of a dataset from Power BI service with a C# program currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature.

As an alternative solution, I'm wondering if you could try using the export report rest api to download the pbix file from Power BI service, then follow steps in this article to export Power BI data to your database in your scenario. 

Regards