Forum Discussion

Reportex's avatar
Reportex
Advocate II
8 years ago
Solved

Report on Report Server Folder Structure

Hi   Is it possible for Power BI to report on itself?   I want to set up a PBI file that reports on the folder structures I have in my Report Server environments so that I can do comparisons betw...
Need Help
Reportex's avatar
Reportex
Advocate II
8 years ago

Thanks for the answers, all very useful.

 

Used the rest-api call in the end using an odata connection to get the catalog items and developed from there:

 

http://<myhost>/reports/api/v2.0/CatalogItems

 

The documentation also mentions being able to retrieve the definition of the report

 

"Using the REST API, you can, for example, navigate the folder hierarchy, discover the contents of a folder, or download a report definition. "

 

But haven't found out a way of doing that yet - any ideas?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    You need https://app.swaggerhub.com/apis/microsoft-rs/pbirs/2.0#/CatalogItems/GetCatalogItem

     

    You pass in the GUID (ID) of the item. It returns the RDL content. Can't say I've used it directly, as you can tell I'm pretty old school and tend to go kick the database until it gives me what I want.

     

    We use the REST API via PowerShell and the ReportingServicesTools library Micorosft Provide.

     

     

    • Reportex's avatar
      Reportex
      Advocate II
      8 years ago

      Thanks stpnet, not quite the report definition I was after, but I'll keep digging.

       

      I'm old school too, but trying to get access to the db at ClientCo would take forever...