Create a data catalog (list of dataflows, datasets, reports, applications) in Power BI

[emgravey]

Hello,

We would like to create a Power BI report that would show the list of our dataflows, datasets and reports... to make a data catalog available to all the users.

How can I do to retrieve this information from our Power BI service platform? We are in premium V2.

Is there any Rest API connector already set to do this?

Thanks for your support

Emmanuelle

[emgravey]

I was able to install the custom connector, is there any way to get the column names of each table in a dataflow or in a dataset?

thanks for your help

[m-colbert]

Power BI REST API custom connector is exactly what you want to use. You can find it here. 
migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Pow...

You will need a gateway to refresh the report in the service. Pretty strightforward explaination on how to use the connector locally and on a gateway here. 

Connector Extensibility in Power BI - Power BI | Microsoft Docs

Thanks

[emgravey]

Hello,

Thanks for your answer.

Is this connector certified and supported when there is an upgrade?

Is this working on the cloud?

Thank you!

[m-colbert]

@emgravey 

Unfortunately, the connector has not been certified. It continues to be improved with regular activity adding new methods and correcting any bugs. I've been using for over a year very successfully and seems to be regularly updated. You can view the update history on github.

In order to refresh in the cloud, it needs to be added to an on-premise gateway. This is all documented here. 

Use custom data connectors with the on-premises data gateway - Power BI | Microsoft Docs

Hope this helps.