Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello
Is there a way to retrieve all measures from one pbix file and export or copy them to a txt file?
That would help for further documentation and as well mass changes if needed.
Cheers.
Solved! Go to Solution.
Hi @Ghuiles,
Yes there is. You can run a DMV query against the Tabular cube.
Essentially you need to connect to your Power BI Desktop instance from a tool such AS Sql Server Management Studio (or MDX Studio) and issue the following Query
Hello
I found a better solution, following that video: https://www.youtube.com/watch?v=rYlIp1PrBcA
Basically, in the DAX Studio, you click on MDSCHEMA_MEASURES.
You get an SQL, execute it and you got a lot of details on your measures.
That you can of course export directly to Excel.
Cheers
Hi @Ghuiles,
Yes there is. You can run a DMV query against the Tabular cube.
Essentially you need to connect to your Power BI Desktop instance from a tool such AS Sql Server Management Studio (or MDX Studio) and issue the following Query
Hi Phil,
This is very helpful. I wonder if DAX Studio can acheive the same result.
Can I use the same query to extract all measures at once and perhaps copy to another dataset to be used in PBI?
Thanks!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.