Preview failed

[giuliapiazza94]

Hi guys,

I don't know why It doesn't work

All the other tables work, this not

Have you ideas?

thank you

[v-yangliu-msft · Accepted solution]

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/...

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.

[giuliapiazza94]

aaah okok, it's the same error.

Thank you 😁

[Anonymous]

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]

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]

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