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.

rusgesig's avatar
rusgesig
Icon for Helper IV rankHelper IV
1 year ago

Same Problem.
Power Query in Excel, the preview for the table I want to merge is blacked out completely - it doesn't even show the columns for me to merge.
This is after pasting the tables as values into a spreadsheet, no connectors or anything.