topic Re: Retrieving report content from API or tables associated from report. in Report Server

Retrieving report content from API or tables associated from report.

Anonymous — Sun, 16 Jun 2024 13:36:55 GMT

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

Re: Retrieving report content from API or tables associated from report.

d_gosbell — Mon, 17 Jun 2024 02:40:08 GMT

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

Re: Retrieving report content from API or tables associated from report.

Anonymous — Wed, 10 Jul 2024 09:20:56 GMT

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

Re: Retrieving report content from API or tables associated from report.

d_gosbell — Wed, 10 Jul 2024 12:04:37 GMT

Anonymous 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.