Forum Discussion

boldwake's avatar
boldwake
Frequent Visitor
9 years ago
Solved

Merging Tables Efficiency Question

PowerBI SuperUsers,   I have a PowerBI filw with two tables pulled from SQL   1) Sales Table 2) Product Table   I"m trying to figure out the most efficient way to merch 2 columns from the prod...
Need Help
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi boldwake,

     

    According to your description, I would suggest you to keeping doing it in DAX for performance purpose. By this way, you can keep making use of the physical relationships to get best performance and the best use of the VertiPaq engine.:smileyhappy:

     

    In addtion, another possible solution is to use the LOOKUPVALUE function. Using LOOKUPVALUE you can denormalize the Brand & Category directly in the Sales table, by defining a new calculated column in Sales table. This solution can make the code simple to author.

     

    Regards

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

You should check whether your query folding is getting done correctly. You can right click the individual Query steps and click on the native Query option. It will show you the SQL Statement in the dialog box. 

 

PowerQuery pushes back some of the operations to the database instead of doing in the Query Editor. This is called Query Folding and For getting better performance, You should check whether your query is getting folded correctly. 

 

Custom SQL Statements for pulling the data from SQL Server does not support Query folding.