How to use Power BI API to get data from report on PBIRS?

Question

Hey all,

I have a Power BI report that is currently uploaded to a PBIRS that I am trying to extract the data from. The report has multiple fields, as seen below:

I would like to use PowerShell with the Power BI API to grab a specific field of data and put it into an Excel file. However, the closest thing I've seen that the API offers to getting data is DataSets, which does not apply to my report. Using REST returns a 404:

Going to the URL specified in the REST command (without /DataSets) returns the metadata of the report, but doesn't mention any of the actual produced data from the fields. Going off of that, would it be possible to access the data for this report through PowerShell, or do I have to do it manually through Power BI Desktop? Thanks!

Answer 1

Hi @Polinkk ,

Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Best regards,
Leon