Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |