Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
is it possible to get the tables associated with a report with DAX query in on-prem server?
@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.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
5 | |
4 | |
1 | |
1 | |
1 |
User | Count |
---|---|
9 | |
4 | |
4 | |
3 | |
2 |