cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Get data using REST API

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft


@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.

 

View solution in original post

9 REPLIES 9
Highlighted
Microsoft
Microsoft

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Microsoft
Microsoft


@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.

 

View solution in original post

Highlighted

@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.

Highlighted

@Jonathan_P

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

Highlighted

Ok great! I just voted as well.

Highlighted

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

Highlighted

@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..

Highlighted
New Member

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

Highlighted

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. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.