Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Helper IV
4 years ago
Solved

Preview failed

Hi guys, I don't know why It doesn't work All the other tables work, this not     Have you ideas? thank you  
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  giuliapiazza94 ,

    Does your two tables have some kind of dependency, one referencing the other?

    For example, if you want to merge table A and table B, but table B itself is merged from table A with other tables. At this time, table A and table B are merged. Will show an error like this.

    https://community.powerbi.com/t5/Power-Query/Not-being-able-to-merge-two-tables-in-Power-Query/td-p/1127628

     

    You can also update power bi desktop to the latest version.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

It may have timed out. Depends on your data source origin. Try refreshing the preview. If it does not work, save your progress, close Power Query & Power BI, open again and retry. 

giuliapiazza94's avatar
giuliapiazza94
Helper IV
4 years ago

I've tried and it doesn't work. The second table is a file excel (like the others that work).

If I do the merge in a new query it works. I don't understand šŸ˜…

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I'm happy that you could solve it! Yes, sometimes weird stuff happens on Power Query haha šŸ™‚