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 Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

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.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps