fetch results from api and store in DB

[powerbiexpert22]

i want to fetch power bi metadata in terms of number of reports, datasets and workspaces and store in Snowflake database. how to acheive this?

[tharunkumarRTK · Accepted solution]

@powerbiexpert22 

Step 1: Extract Workspace metadata - 

I would suggest you to write a python script to run Power BI Scanner APIs. 

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

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

Step 2: Load the data into Snowflake database - 

You can further leverage python script to load the medata data to snowflake. Here is article which might help you:

https://medium.com/snowflake/loading-f1-historical-data-into-snowflake-using-the-ergast-developer-ap...

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[aj1973 · Accepted solution]

Hi @powerbiexpert22 

With PowerShell you can write scripts to call Power BI Rest APIs 

https://learn.microsoft.com/en-us/rest/api/power-bi/admin

Extract the logs in JSON or CSV formats then send the extracted files store them in Snowflake.

Finally connect Power BI desktop to build your report.

[SaiTejaTalasila]

Hi @powerbiexpert22 ,

You can use fabric notebooks and admin api and need create programs to extract data and insert into snowflake database.If required you need to stage the data in onelake.Even it's possible to do something using powershell and vs code.

I hope it will be helpful.

Thanks,

Sai Teja 

[tharunkumarRTK · Accepted solution]

@powerbiexpert22 

Step 1: Extract Workspace metadata - 

I would suggest you to write a python script to run Power BI Scanner APIs. 

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

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

Step 2: Load the data into Snowflake database - 

You can further leverage python script to load the medata data to snowflake. Here is article which might help you:

https://medium.com/snowflake/loading-f1-historical-data-into-snowflake-using-the-ergast-developer-ap...

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!