Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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:
Any advice, during this early planning stage would be welcome
Cheers
Steve
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:
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Proud to be a Super User!
@Anonymous , Have you explored this option
https://azure.microsoft.com/en-in/blog/connecting-power-bi-to-an-azure-analysis-services-server/
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |