Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to Query Report folder structure of PowerBI report server and see all the hierarchy of folders ?

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...
Help required
tricks and tips
  • d_gosbell's avatar
    d_gosbell
    5 years ago

    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

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    5 years ago
    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