list formulas from a report

[ggittons]

Does anybody know if its possible to extract into a single list all the formula from a specific report?

[Baskar]

Have alook on this vedio it will solve your problem.

http://www.sqlbi.com/tv/vertipaq-analyzer-1-7/

[Phil_Seamark · Accepted solution]

Download DAX Studio

run the following against your PBI Desktop (one at a time)

select * from $SYSTEM.TMSCHEMA_MEASURES
select * from $SYSTEM.TMSCHEMA_COLUMNS where [Type]  = 2;

[v-ljerr-msft]

Hi @ggittons,

If you want to list formulas from a report for better managing all the measures, here is a similar idea shared on Power BI Ideas. You can vote it up and add your comments there to improve Power BI on this feature.

Regards

[ibarrau]

I don't believe it's possible to extract all your dax formulas to a list automatically. However you can copy all the formulas in power query listed in "Advanced Editor".

[KHorseman]

Get Dax Studio. You can extract all sorts of things with that, including measures.