Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Confused about joins

I'm used to writing SQL queries, but new to Power Query.   I'm struggling a bit to break out of my habbits.   I have a selection of one table (T1), that results in a few hundred lines.   I need...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    You're thinking too much in the moment - think end-product:

     

    Once you've done your T1/T2 merge, you right-click on the T2 query and UNCHECK 'Enable Load'. This prevents this query having to be run when you actually refresh your report in the service, as it doesn't need to be materialised for the data model. This just leaves your merged T1 query to be run which, as you can see, has all the details it needs within its folded native query to produce your merged T1 in the model.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

You're thinking too much in the moment - think end-product:

 

Once you've done your T1/T2 merge, you right-click on the T2 query and UNCHECK 'Enable Load'. This prevents this query having to be run when you actually refresh your report in the service, as it doesn't need to be materialised for the data model. This just leaves your merged T1 query to be run which, as you can see, has all the details it needs within its folded native query to produce your merged T1 in the model.

 

Pete

Anonymous's avatar
Anonymous
Not applicable
4 years ago
BA_Pete wrote:

Once you've done your T1/T2 merge, you right-click on the T2 query and UNCHECK 'Enable Load'. This prevents this query having to be run when you actually refresh your report in the service, as it doesn't need to be materialised for the data model.

There it is! That's exactly what I was missing.

 

Thanks so much. After doing this, my refresh is much, much lighter.