Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Bridge Table - Do in PowerQuery or in Dax?

Hi

 

I'm creating a bridge table, but I'm unsure about if this must be done in PowerQuery thought a Reference or thought a DAX expression.

If I create it thought a DAX expression, it's very quickly.

If I create it thought PowerQuery, using reference table, at least the first time, it takes a lot of time because it reloads the whole table from server.. (No idea why..)

 

What is the best option?

As far as I know, if created in PowerQuery, the optimization of the in-memory table is better, because it can compress data, while in DAX no.

 

Thanks!

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

I've found several third-party blogs which may help you:

https://radacad.com/m-or-dax-that-is-the-question

https://technologyblog.rsmus.com/microsoft-dynamics/dynamics-365-for-finance-and-operations/difference-m-dax-in-power-bi/

https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

I've found several third-party blogs which may help you:

https://radacad.com/m-or-dax-that-is-the-question

https://technologyblog.rsmus.com/microsoft-dynamics/dynamics-365-for-finance-and-operations/difference-m-dax-in-power-bi/

https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous ,

 

check this Blog Post from Chris Webb

Why Does Power BI Query My Data Source More Than Once?

https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/

Maybe it helps.

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Greg_Deckler
Community Champion
Community Champion

In general, the more that you can move data manipulation up the "food chain" towards the source the considered the better way to go. That being said, DAX makes it super convenient to do these kinds of things. Also, to your point about efficiency, both methods would have the same efficiency in terms of data storage in the model. I would expect that after the first time, the Power Query would be faster than the DAX in terms of loading the data into the model but I have not tested that.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.