question

Cataster-7485 avatar image
0 Votes"
Cataster-7485 asked ZoeHui-MSFT commented

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

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.


sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @Cataster-7485,

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·