Forum Discussion

mchacha's avatar
mchacha
Frequent Visitor
2 years ago
Solved

Impossible to merge - Preview not available

Hi,   I'm trying to merge my main query (which comes from excel source A) to another one (excel source B), but I can't as it says Preview not available.  I've already merged some info from main qu...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PwerQueryKees's avatar
    PwerQueryKees
    2 years ago

    Without the details of the various queries it is hard to say what is wrong exactly, so I am just guessing here...

    BUT:

    You mention "DN and invoices table, I merge it with Shared list extraction".
    It is causing a dependency because the merge you did earlier now suddenly refers to itself because of the merge you try to do,

    You can try to make a new query refering to Shared List Extraction and join that new query with DN and Invoices.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You need to indicate which column(s) you want to merge the tables on.

 

Note:  Merging in Power Query is very expensive. Avoid if possible.  Use the data model instead.

  • mchacha's avatar
    mchacha
    Frequent Visitor
    2 years ago
    Hey, thanks for your reply. The thing is, even if I select a column in my first table, I'm not able to select a column in the second as it doesn't load. Thank you for the tip, I didn't know. However, I wanted to merge my two tables with my invoice number. As I have more/different invoices in one table compare to the other, I'm afraid I can't use the data model to create relations?