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.

PwerQueryKees's avatar
PwerQueryKees
Icon for Super User rankSuper User
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.