undefined

[Anonymous]

Hi i need a help
we have Power BI reports in services 

we are using multiple data source like sharepoint, snowflake ,sql

and we need to create a report like how many reports are using snowflake as a datasource and how many users using it and their names

[Anonymous · Accepted solution]

Hi @Anonymous ,

The fastest way is to call the scan restful api of power bi.

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-get-scan-result

You can find the corresponding semantic model through the data source id.

And it will return the users who use this semantic model.

Similarly, you can get the report and the list of users who use the report based on the Dataset ID.

Best Regards,

Wearsky

[SaiTejaTalasila]

Hi @Anonymous ,

If you have your pbix files then you can create a python script to convert it to a zipfile and scan through the metadata and get those details to a dataframe and finally you can save it to a CSV file.Even the same method you can make it work for dataflow json files.

I hope it will be helpful.

Thanks,

Sai Teja 

[Anonymous]

Hi sai teja  thanks for your responce do we have any sample or any document or video to reffer how to convert into python script 

[collinq]

HI @Anonymous ,

You can use the Power BI REST API here:  Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

For your request specifically, look at the "Datasets" section.

[Anonymous]

Thanks for your responce i will go throuht it