Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can I read data from DMV views in a report that is published to the service?
I want to retrieve a dataset that contains meta-data about the report I am using. Specifically for now I just want to know some simple details about the internal model of the report:
select [Name], [Version], [ModifiedTime], [StructureModifiedTime] from $SYSTEM.TMSCHEMA_MODEL
I can do this as expected while I am authoring in the PBIDesktop by connecting to the local machine with DAX studio, here is an example result set:
I want my report to be "self aware" while it's published to the service, but I can't figure out how to make a connection that I can publish to the service. I was hoping I could create a connection to the service using the new connector (https://powerbi.microsoft.com/en-us/blog/connecting-to-datasets-in-the-power-bi-service-from-desktop... ) but I can't figure out how.
Any suggestions experts? I've used this approach against SSAS models in the past with success, I'm hoping to accomplish something similar with PBI models.
You can get this with "analyze in excel." from the pivot table that points at your power bi service data source, you can drill through to create a new table, then change that table's query to whatever you want. Your specific query example worked for me on one of my data sets.
Hi @mow700,
Considering how it(reading DMV data from pbix file) works, I don't think there is a way to read data from DMV views in a report that is published to the service currently.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.