Retrieving dataset structure and report source tables from the Rest API

[Anonymous]

Hello,

I am in the process of developing an application that lists the reports of a group, the associated datasets as well as the tables of these datasets that are used to generate the reports. The goal is to have an overview in a tool parallel to PowerBI. I go through the Rest API by authenticating my application through the Client Credentials method. I am able to retrieve the list of reports and the associated dataset id and name, but I can't find any way to retrieve more information. Is there a way around this limitation? Is there an alternative to the Rest API that allows me to retrieve more information? Or maybe the data I can retrieve from the API depends on my subscription?

Thank you !

[GilbertQ · Accepted solution]

Hi @Anonymous 

You are in luck in that there is a new Scanner API that has been released where you can get all this information, here are the details: Announcing Scanner API (Admin REST APIs) enhancements to include dataset tables, columns, measures, DAX expressions, and mashup queries | Microsoft Power BI Blog | Microsoft Power BI

[rjhale]

Is it possible to use the new Scanner API endpoints without being a full Global or Power BI admin? 

I work in a large organization and manage around 25 workspaces with a lot of dataflows and datasets/reports, but I'm not a Power BI Admin in the tenant.  I'm using the other API endpoints in our environment successfully, so I would like to know if it's even possible for me to use the new Scanner APIs before putting in the request. 

Thanks. 

[Anonymous]

Wow what a great coincidence ! I will explore this way, thank you !