Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
How can I get a full list of all dashboards / reports created in my organization?
My organization is using O365. I am the admin portal and have access to PBI admin portal site where I can see the "usage metrics". I can see "Number of Dashboards", "Number of User Reports", "Number of Datasets", but only as number, from where i can get the list, the report name, creation date, etc...
Thanks,
RT
Solved! Go to Solution.
@raedt You can use the REST APIs outlined here to pull everything out of the environment. I've done this using Postman as a ad hoc engine to execute them.
https://docs.microsoft.com/en-us/rest/api/power-bi/dashboards
Hi @raedt ,
You can use PowerShell to get a list of all reports and dashboards in your organization.
Install-Module -Name MicrosoftPowerBIMgmt
Connect-PowerBIServiceAccount
Get-PowerBIDashboard -Scope Organization | Out-file D:\DashboardList.txt
Get-PowerBIReport -Scope Organization | Out-file D:\ReportList.txt
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Everyone, I am interested in this topic, on top of this answer, how is it possible to retrieve the company of the user because If have the list of user reports without his line of business to which he belongs, I will have difficulties to sort all the reports? How can i do that please? thank you for your answer!
Why on earth would MSFT make it soooooo difficult to get a list of your content - it's one of the most obvious things you'd ever want to do on a PBI Service....absurd!
Hi @raedt ,
You can use PowerShell to get a list of all reports and dashboards in your organization.
Install-Module -Name MicrosoftPowerBIMgmt
Connect-PowerBIServiceAccount
Get-PowerBIDashboard -Scope Organization | Out-file D:\DashboardList.txt
Get-PowerBIReport -Scope Organization | Out-file D:\ReportList.txt
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I get below error when I run this code
Get-PowerBIDashboard -Scope Organization -Id a12345bc-d123-1j36-a12b-ab012345kl8e | Out-file C:\Users\amal.eranda\ReportList.txt
Get-PowerBIDashboard : Operation returned an invalid status code 'Unauthorized'
At line:1 char:1
+ Get-PowerBIDashboard -Scope Organization -Id a12345bc-d123-1a23-a12b- ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...owerBIDashboard:GetPowerBIDashboard) [Get-PowerBIDashboar
d], HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'Unauthorized',Microsoft.PowerBI.Commands.Repo
rts.GetPowerBIDashboard
@Icey can you kindly post how would you get the list of contents from a specific workspace. Thanks a lot
You can also use T-SQL
SELECT
Name,
FullPath = [Path]
,ReportParentPath = REVERSE(SUBSTRING(REVERSE(Path), CHARINDEX('/', REVERSE(Path)), LEN(REVERSE(Path))))
--,[Description]
,*
FROM [dbo].[Catalog]
WHERE 1=1
AND [Type] IN (2,13)
ORDER BY [Path]
SELECT [Type], count(*)
FROM [dbo].[Catalog]
WHERE [Type] IN (2,13)
GROUP BY [Type]
What database are you in for these queries?
@raedt You can use the REST APIs outlined here to pull everything out of the environment. I've done this using Postman as a ad hoc engine to execute them.
https://docs.microsoft.com/en-us/rest/api/power-bi/dashboards
I would like to know how using Rest API with Postman please? Especially for this case
Thank you
Hi, it seems that rest api is used for embed, and it requires me to enter a URL, so I'm not able to register an app. Can you let me know more details on how to get it set up and use it with Postman please? Thank you.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
38 | |
27 | |
17 | |
16 | |
8 |
User | Count |
---|---|
46 | |
38 | |
34 | |
16 | |
16 |