Retrieving report content from API or tables associated from report.

[MikeVelotix]

Hey all,

I am using PowerBi Report Server (on-prem), I am looking to ways to get report metadata, tables and it's columns which are associated to the report in REST API.

As I have seen there isn't an official API for that, I heard there is an API for downloading the .pbix file, which I want to try to get the information from that file.

ChatGPT suggested:
curl --ntlm -u "username:password" -X GET "http://your-report-server/Reports/api/v2.0/PowerBIReports/{report-id}/Content/$value" -o "path_to_save_report.pbix"

but it was pure hullicanations and there isn't such endpoint from what I tested.

Would like some help

[MikeVelotix]

is it possible to get the tables associated with a report with DAX query in on-prem server?

[d_gosbell]

---

@MikeVelotix wrote:

is it possible to get the tables associated with a report with DAX query in on-prem server?

---

No, you cannot run DAX queries against a data model hosted in the on-prem Report Server. It does not expose an XMLA endpoint.

[d_gosbell · Accepted solution]

It's not a pure hallucination, you need to use pass the report id in brackets eg:
http://your-report-server/Reports/api/v2.0/PowerBIReports({report-id}}/Content/$value

see Power BI Reports - Get Power BI Report Content - REST API (Power bi report) | Microsoft Learn