Get data using REST API

[Jonathan_P]

Hello,

I would like to know if there is a way to get the data from a report using REST API. We want to have a client application that can pull the data. My application is registered on Azure. I was able to do some successful calls like getting the datasets list.

I read the following documention but I can't find something about the reports itself.

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-rest-api-reference/

https://msdn.microsoft.com/en-us/library/mt147898.aspx

The following link show that there is some permissions for reports (to see data). But I can't find the documentation of that API.

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-power-bi-permissions/

Can you help me please?

Thanks

[v-pn]

Jonathan - were you able to achieve this ? I have the same requirement and have not been able to figure out a way yet.

[Anonymous]

Best work on this one.  Tableau can do this with nice JSON returned data.  I'd rather do it here.  It is no more than the "Show Data" function, should be straightforward. 

[Eric_Zhang · Accepted solution]

---

@Jonathan_P wrote:

Hello,

I would like to know if there is a way to get the data from a report using REST API. We want to have a client application that can pull the data. My application is registered on Azure. I was able to do some successful calls like getting the datasets list.

I read the following documention but I can't find something about the reports itself.

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-rest-api-reference/

https://msdn.microsoft.com/en-us/library/mt147898.aspx

The following link show that there is some permissions for reports (to see data). But I can't find the documentation of that API.

https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-power-bi-permissions/

Can you help me please?

Thanks

---

Getting data using REST API is not possible at this moment, you can check and vote up this idea REST API access to READ datasets.

By the way, why would you like to get the data from the report? As reports are basing on variours data sources, you can get data from the data sources in your scenario.

[gareta]

Accessing those sources directly and performing the same operations in code is redundant to work already handled elegantly in powerbi.

[Jonathan_P]

@Eric_Zhang, thanks for the clear answer. To answer your question, we want to pull the data from the report for the same reason a user would use the 'Export data' fonctionnality on a report visualization. I think that in some cases pulling the data using a registered client application is a real-life scenario. Let me know if I am still unclear.

[karinaj]

@Jonathan_P Were you able to achieve this, aka reading data from a power BI's report? I am trying to achieve the same as I dnt want to get into the business of accessing data from my target report's data source which is sql. I rather call a rest api/odata feed to get this data.

thanks..

[Eric_Zhang]

@Jonathan_P

Thanks for clarification. I've voted for that idea.

[Jonathan_P]

Ok great! I just voted as well.

[Phil_Seamark]

I believe you can get info on Datasets, Dashboards and reports but not get at the actual data. 

The only functions you can perform that are data related at the moment are to add rows, or clear all loaded data. 

Obviously you can use Excel to connect to a Power BI report up in the service and run pivot tables but unsure if that is built on REST, or if it's something you can tap into as yet.

If your report uses on premise data sources (SSAS, SQL etc) then you have no problem.