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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mchacha ,

 

-- then in my report information would be taken from two different tables?

 

Yes. The duplicate creates an exact copy of the original query, including all the steps applied to it. Changes made to the duplicate do not affect the original query, and vice versa. 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

mchacha's avatar
mchacha
Frequent Visitor
2 years ago

The issue is, I've already created many different tabs, visuals and measures from the original one - it wouldn't be a lasting solution to do a copy then merge on the copy. Moreover, I guess it will load it twice and the original won't be useful anymore ? 😞 

The thing is, when I do the opposite (merge from table DN and invoices the table Shared list extraction) it works... 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi mchacha ,

    The duplicate copy table can be right-clicked and unchecked Enable load, so that it is not loaded into the model, and you can still use the original table with the created visual and measures.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum