Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to Query Report folder structure of PowerBI report server and see all the hierarchy of folders ?
I would like to query PowerBI report server and want to see how folders have been organized .I want the nested structure so that I can make decision in re-designing the folders based on my Business line and sub departments.
I m technical user and not want to see what data is present in the reports but just the structure and objects on report server .
Solved! Go to Solution.
You can also do this in a Power BI Report using an OData connector and connecting to the following endpoint
http(s)://<yourserver>/reports/api/v2.0/CatalogItems
This has a report path column which you can split on / characters to create a hierarchy
You can also do this in a Power BI Report using an OData connector and connecting to the following endpoint
http(s)://<yourserver>/reports/api/v2.0/CatalogItems
This has a report path column which you can split on / characters to create a hierarchy
Got a error via OData connector using windows auth
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"
@Anonymous wrote:
Got a error via OData connector using windows auth
Sorry, there should be a /reports (or whatever you have configured for your portal url) in front of the /api so the endpoint should be as follows
http(s)://<yourserver>/reports/api/v2.0/CatalogItems
You could try starting with something like this SQL and modify it from here. You'll need access to the SQL Server and the ReportServer database.
USE [ReportServer]
GO
SELECT CATALOG.NAME
,CATALOG.[Path]
,DataSource.NAME datasource
,CATALOG.[Description]
,Created.UserName AS CreatedByUser
,CATALOG.[CreationDate]
,Modified.UserName AS ModifiedByUser
,CATALOG.[ModifiedDate]
FROM [dbo].[Catalog]
LEFT JOIN (
SELECT [UserID]
,[UserName]
FROM [dbo].[Users]
) AS Created ON CATALOG.CreatedByID = Created.UserID
LEFT JOIN (
SELECT [UserID]
,[UserName]
FROM [dbo].[Users]
) AS Modified ON CATALOG.ModifiedByID = Modified.UserID
JOIN DataSource ON CATALOG.ItemID = DataSource.ItemID
JOIN CATALOG cat1 ON DataSource.Link = cat1.ItemID
WHERE CATALOG.[Type] = 2
ORDER BY [Path]
,NAME