Is it possible to parse through the DataSet using on-premise PBI API?

Question

We have a PBIX report that is hosted on PowerBI on premise, meaning the Report Server portal is configured on our Datacenter. with that version we noticed some features are not accessible to us like subscriptions that the PowerBI Cloud version would have instead.

Ive been able to use the REST API as follows for some use cases like updating the DataSource connection credentials and parsing through RefreshCachePlans.

Invoke-RestMethod -UseDefaultCredentials -uri "$baseURL/api/v2.0/PowerBIReports(path='$reportPath')"

Can we use it for extracting actual data from the report? like data from a table?

I looked at the odatacontext json response and there is no hint of datasets in it, but some articles online like this one has an approach using "DataSets". However I think this may be applicable only to the PowerBI Cloud, but please correct me if im wrong.

Answer 1

Hi @Cataster ,

It seems that your issue is related with Power BI Reporting Server, we'd suggest that you may post the issue to PBIRS forum.

Microsoft Power BI Community

You may get more accurate information in the corresponding forum.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October