Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Management View (DMV) queries against PowerBI model. How to automate load into DB?

Hi  I have been using SQL Server Management Studio to manually execute DMVs to query XMLA endpoints in our PowerBI Premium workspaces. These queries return useful information on the underlying PBI S...
Need Help
tackytechtom's avatar
tackytechtom
Most Valuable Professional
3 years ago

Hi guys,

 

Though late to the party, I'd like to share two blog posts that might be of help for others.

 

If you'd like to analyse the model with Power BI, why not directly connecting Power BI with the meta data of the dataset? This post shows a way to do this:

https://www.tackytech.blog/how-to-build-meta-reports-on-top-of-power-bi-datasets-with-dynamic-management-views-dmvs/

 

If you really want to save the data from the DMVs into a database (i.e. Azure SQL Database), you can look into the following one, too. The blog post uses Azure Data Factory, but you could use any other tool really. It utilises the "executeQueries" Power BI API in a copy activity (source: executeQueries API, target: Azure SQL Database). Interesting enough you can not only query the meta data (via DMVs) from the dataset but also the actual tables.

https://www.tackytech.blog/how-to-query-and-copy-data-from-power-bi-datasets-via-azure-data-factory/

 

Hope this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/