Forum Discussion
Data source error: We cannot convert the value "[Table]" to type Table
That was the same issue also in my case.
I resolved the issue in Query Editor. I tried to remove queries one by one unless it started to work again (refresh in PBI service). And If I remember well I found out that it was caused by merge step. When I changed transformation rules, it started to work well again.
Best Regards,
Lubos
OK thank you Lubos.
Can you remember what type of transformation rule was the root cause?
It was merge from other table. But I don't remember the real root cause, because I still use merge transformations very often. I reccomend to identify query, which cause the problem and then try to remove merge from this query. If it will not fix the problem, I reccomend to remove transformations step by step in query editor to find out the root cause.
