Forum Discussion
zahlenschubser
Helper IV
Helper IVWeird error with refreshing combined tables
I have a rather strange issue with one of my combined tables when refreshing the dataset. The first time I'm refreshing the data (usually in the morning) I am getting an access / references error...
I managed to solve the issue by joining the tables on import in the power bi query SQL option with UNION ALL.
I solved the problem by pulling the columns with sql code in the power bi query and using UNION ALL to join them at the time of import, so power bi only has one table to deal with.
zahlenschubserHelper IV
Helper IVI solved the problem by pulling the columns with sql code in the power bi query and using UNION ALL to join them at the time of import, so power bi only has one table to deal with.
Hi zahlenschubser ,
It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. It will help the others in the community find the solution quickly if they face the same problem as yours. Thank you.
Best Regards