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

[Anonymous]

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 SSAS database such as:

• M expressions in the model
• Tables in the model
• Relationships between the tables
• Measures & DAX
• Calculated columns

I would like to programtically extract the above information from all our PowerBI Premium workspaces and load it into a central database (probably SQL Azure DB) for further analysis. However,  I am struggling to find relevant information (and examples) on the more complex querying capabilities of DMVs, and scheduling DMVs. Can anyone provide any insight (or links) as to whether:

• DMV Queries (against the PBI Analysis Services database) can be scheduled with a std scheduling tool like SQL Server Agent?
• DMVs support INSERTing data into destination databases in a SQL tables. I see references that DMV Syntax is very limited, so no JOINS ().
• Or would I be better off, taking a more pure script based approach and doing it in Python. 

Any advice, during this early planning stage would be welcome

Cheers
Steve

[vanessafvg]

https://www.fourmoo.com/2021/11/24/how-did-i-keep-my-power-bi-dataset-measures-documented-and-up-to-...

[amitchandak]

@Anonymous , Have you explored this option

https://azure.microsoft.com/en-in/blog/connecting-power-bi-to-an-azure-analysis-services-server/

[Anonymous]

Hi @amitchandak Thanks for your suggestion. 

We aren't in a position to change our Enterprise Architecture. So this isn't an option.

Thanks again

Steve