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.