Forum Discussion

KenHardwick's avatar
KenHardwick
Frequent Visitor
7 years ago

Merge queries painfully slow

Hello,   I am writing a new report in Power BI that requires me to merge two tables/queries together which I have done via the merge as new function.   When I do a refresh the data the standard t...
Need Help
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

What is the dataformat on the columns that you are using for your merge?

KenHardwick's avatar
KenHardwick
Frequent Visitor
7 years ago

Currently, the tables are still in their original formats within our ERP system so will be various formats.

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    But I mean you're doing the merge in power query right? 

    • KenHardwick's avatar
      KenHardwick
      Frequent Visitor
      7 years ago

      Thats right. 

      • tex628's avatar
        tex628
        Icon for Community Champion rankCommunity Champion
        7 years ago

        In that case you are using 2 or more columns to perform that merge. What I'm interested in is which datatype these columns have prior to the merge, as that can greatly affect the performance. :-)