Forum Discussion
Data Refresh issues with Appended Tables
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
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!
Hi owenbolick
I wanted to check in to see if the suggestions shared earlier by freginier helped resolve the refresh error you were experiencing in your report.
As highlighted, this type of issue often occurs when combining DirectQuery and Import tables in appended queries. You might try avoiding references to DirectQuery tables within Import queries, or, if feasible, convert all related tables to Import mode to keep things consistent.
If this solution worked for you, please consider marking the response as accepted — it can really help others who run into the same issue.
And if the problem persists or you need alternative solutions, don’t hesitate to ask. We’re here to help!
If we don’t hear back, we may close this thread in line with our community guidelines, but you’re always welcome to post a new query anytime.
Thank you for being part of the Microsoft Fabric Community!
