cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BaluChalla
Helper II
Helper II

How to get list of reports in power BI

Hi Team,

Is their any option to get list of all power BI reports. Please help me if yes.

 

Thanks

1 ACCEPTED SOLUTION
FarhanAhmed
Super User II
Super User II

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

 

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
d_gosbell
Super User II
Super User II

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

josef78
Continued Contributor
Continued Contributor

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

FarhanAhmed
Super User II
Super User II

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

 

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.