Weird error with refreshing combined tables

[zahlenschubser]

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 that blocks the other queries.

If I go into the editor and refresh the table there, it loads fine.

Same if I close the BI and try again a bit later.

The columns in the tables I'm combining have the same names, and the formula in the merged table is just a simple
= Table.Combine({import_A, import_B, import_C})

If I redo the merging the formula in the new table looks exactly the same too, and gives the same weird error.

The source tables themselves are loaded from a mysql database, but that one is accessible and properly loads the other tables, so I don't see the issue there.

[zahlenschubser · Accepted solution]

I managed to solve the issue by joining the tables on import in the power bi query SQL option with UNION ALL.

[zahlenschubser · Accepted solution]

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.

[Anonymous]

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

[Anonymous]

Hi @zahlenschubser ,

This type of error may caused by a number of reasons, please review the following links and check if the solution can help you resolve the problem.

1. Caused by data privacy levels

Dealing with errors - Power Query | Microsoft Learn

Solved: References other queries or steps, so it may not d... - Microsoft Power BI Community

I was able to figure it out. It looks like I had to set the privacy level to `Organizational` on both the Dekstop version and the service level. 

---

2. Caused by combined external source

Power Query Errors: Please Rebuild This Data Combination (excelguru.ca)

Best Regards

[zahlenschubser · Accepted solution]

I managed to solve the issue by joining the tables on import in the power bi query SQL option with UNION ALL.