Forum Discussion
Data Refresh issues with Appended Tables
Hello,
I am getting this error when I try to refresh data in one of my reports. It normally does this right when I load it, but the next time it will work. I am pretty confused on it. I was reading online I need to change all of my data sources to import to fix this, but when I tried that it gets stuck at "waiting on queries".
My four main tables are DirectQuery, and then have about 15 other ones that are imports from the same source. Some of them are appended as well. Not really sure what my plan is for this, I ended up with so many tables because more requests kept coming in for the report and I was just bringing in tables and making relationships for them to work. The report itself is complete, this is the only issue I have been running into.
Any advice is appreciated. Thank you in advance.
Hello
You're hitting a data combination issue caused by mixing DirectQuery and Import tables in appended queries. To fix it, avoid referencing DirectQuery tables in Import queries, or switch everything to Import mode if possible. You can also do the appends upstream (e.g., in SQL or a Dataflow).
freginier
4 Replies
Hello
You're hitting a data combination issue caused by mixing DirectQuery and Import tables in appended queries. To fix it, avoid referencing DirectQuery tables in Import queries, or switch everything to Import mode if possible. You can also do the appends upstream (e.g., in SQL or a Dataflow).
freginier
Hi owenbolick
I wanted to follow up to see if the suggestions shared earlierby freginier helped clarify your question abougetting this error when I try to refresh data in one of my reports.
If this resolved your issue, please consider marking the response as accepted, as it may help others with similar questions.
However,a data combination issue caused by mixing DirectQuery and Import tables in appended queries. To fix it, avoid referencing DirectQuery tables in Import queries, or switch everything to Import mode if possible.
We’re happy to help explore other options if needed.
Thank you for being part of the community!
Hi owenbolick
I wanted to follow up to see if the suggestions shared earlier by freginier helped address the error you encountered when refreshing data in your report.
As mentioned, this issue often happens due to a data combination conflict when mixing DirectQuery and Import tables in appended queries. To resolve it, you might try either avoiding references to DirectQuery tables within Import queries, or switching all related tables to Import mode if that’s possible for your scenario.
If this solution worked for you, it would be great marking the response as accepted it could help others facing the same challenge.
Of course, if you’re still running into difficulties or need a different approach, we’re here and happy to help further!
Thank you for being part of the community!
