cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
campagnol54 Regular Visitor
Regular Visitor

How to search a string in all DAX formulas of a Power BI desktop report ?

Hello,

 

I would like to look for a string included in my DAX formulas. Is there any way to do it ?

I unzipped the pbix file but I couldn't find my DAX formulas in any file.

Subsequently, it would be great to export/edit all DAX formulas to be able to compare them.

 

Thanks in advance for any help

Didier

2 ACCEPTED SOLUTIONS

Accepted Solutions
campagnol54 Regular Visitor
Regular Visitor

Re: How to search a string in all DAX formulas of a Power BI desktop report ?

I found a much better way by searching from a Power BI report. You can even search in more than one report. 

Of course, you can export the formulas into Excel.

 

Image 6.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

User manual and sources are in the first tab of the report in GitHub : https://github.com/didierterrien/Power-BI-assistant

View solution in original post

campagnol54 Regular Visitor
Regular Visitor

Re: How to search a string in all DAX formulas of a Power BI desktop report ?

 

I moved the pbix file to GitHub :  https://github.com/didierterrien/Power-BI-assistant

 

Very good tutorial by Ruth Pozuelo (Curbal) : https://www.youtube.com/watch?v=Jg7n_cLjtTw

View solution in original post

5 REPLIES 5
Community Support Team
Community Support Team

Re: How to search a string in all DAX formulas of a Power BI desktop report ?

@campagnol54,

 

As far as I know, there is no way available. You may submit an idea via https://ideas.powerbi.com/forums/265200-power-bi.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
campagnol54 Regular Visitor
Regular Visitor

Re: How to search a string in all DAX formulas of a Power BI desktop report ?

I found a way to do it in DAX studio after connecting to the Power BI report:

//  Uncomment the query you need

//  Query to get columns :
//select [ExplicitName] as [Column name], [Expression] as [Formula] from $SYSTEM.TMSCHEMA_COLUMNS where [Type]=2 and [SystemFlags]=0

//  Query to get measures :
select [Name] as [Measure name],[Expression] as [Formula] from $SYSTEM.TMSCHEMA_MEASURES

 

kevhav Member
Member

Re: How to search a string in all DAX formulas of a Power BI desktop report ?

So glad I found this on the community board, here.

 

I tried this and it worked. This is a huge help. Thanks @campagnol54!

campagnol54 Regular Visitor
Regular Visitor

Re: How to search a string in all DAX formulas of a Power BI desktop report ?

I found a much better way by searching from a Power BI report. You can even search in more than one report. 

Of course, you can export the formulas into Excel.

 

Image 6.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

User manual and sources are in the first tab of the report in GitHub : https://github.com/didierterrien/Power-BI-assistant

View solution in original post

campagnol54 Regular Visitor
Regular Visitor

Re: How to search a string in all DAX formulas of a Power BI desktop report ?

 

I moved the pbix file to GitHub :  https://github.com/didierterrien/Power-BI-assistant

 

Very good tutorial by Ruth Pozuelo (Curbal) : https://www.youtube.com/watch?v=Jg7n_cLjtTw

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 56 members 1,248 guests
Please welcome our newest community members: