Forum Discussion
Retrieving report content from API or tables associated from report.
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
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/$valuesee Power BI Reports - Get Power BI Report Content - REST API (Power bi report) | Microsoft Learn
3 Replies
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/$valuesee Power BI Reports - Get Power BI Report Content - REST API (Power bi report) | Microsoft Learn
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.