Forum Discussion

marktvc's avatar
marktvc
Helper I
5 years ago
Solved

Merge data without loading both tables

Hi All,   I looking for an option to load data from to SQL tables in to one FACT table withouth having to load the second table.   I have used the "Merge Query" option, but that requires the seco...
  • Jimmy801's avatar
    5 years ago

    Hello marktvc 

     

    what is wrong in using the merge? However you have to load the second table in one way to other. And even if you merging both tables, and extracting only one column of your second table, Power query will not load all the second table but only the columns needed. How is the performance?


    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy