appending imported data in power query causes direct query error

Question

I have 2 tables that i have appended in power query, and i can seem them fine in query editor, appended, but when i load them in into the front end of power bi i get an error saying error with direct query, which is odd because im not even using direct query.&nbsp; any clues?

v-lili6-msft · Answer

Hi@ vanessafvgYou may try to disable Composite Models and append two table again&nbsp;Best Regards,Lin

vanessafvg · Answer

v-lili6-msft&nbsp;oh boo i tried that but to no avail&nbsp;

v-lili6-msft · Answer

hi,@vanessafvg&nbsp; &nbsp;This is likely happening because the composite models preview feature is turned on.you may try to disable other&nbsp;preview feature and try it again.and the&nbsp;same issue has been reported internally&nbsp;before: CRI&nbsp;79697545.&nbsp;Reference:https://community.powerbi.com/t5/Issues/Power-Query-reports-about-noncompatible-DirectQuery-mode-for-a/idc-p/493098/label-name/apis%20and%20embedding&nbsp;&nbsp;Best Regards,Lin&nbsp;

Forum Discussion

appending imported data in power query causes direct query error

3 Replies

Related content

Dataflow - Append

Appending Data

Error causing pipeline failure

Merge queries causing duplicate records

Event based trigger causing duplicate runs