Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Is their any option to get list of all power BI reports. Please help me if yes.
Thanks
Solved! Go to Solution.
You can query your PBI Report Server Database Catalog Table to get the list of all objects in Server. 13 is for reports only.
SELECT *
FROM [ReportServer].[dbo].[Catalog]
Where Type=13
Proud to be a Super User!
You can also get this with the PBIRS REST API. (you would replace "localhost" with the name of your actual server)
eg.
http://localhost/reports/api/v2.0/PowerBIReports
This returns an ODATA feed so you could use this in Power BI Desktop to get a list of all the Power BI Reports on your Report Server
Additionally, you can get list of reports using PowerShell commands, or you can get list of report using PBI API, using Odata connector (also from PBI Desktop).
Can you be a bit more specific?
And these solutions seem geared towards on an premise Power Bi solution. Anything for the cloud based solutions: https://app.powerbi.com/groups/...?
@wsdcawefwqrevfq wrote:
And these solutions seem geared towards on an premise Power Bi solution.
That is because this forum is specifically focussed on the on-prem solution.
Questions about the cloud service can be asked here Service - Microsoft Power BI Community
You can query your PBI Report Server Database Catalog Table to get the list of all objects in Server. 13 is for reports only.
SELECT *
FROM [ReportServer].[dbo].[Catalog]
Where Type=13
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |