cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

appending imported data in power query causes direct query error

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.  any clues?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
3 REPLIES 3
Community Support Team
Community Support Team

Re: appending imported data in power query causes direct query error

Hi@ vanessafvg

You may try to disable Composite Models and append two table again

7.png

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: appending imported data in power query causes direct query error

@v-lili6-msft oh boo i tried that but to no avail

 

Capture.PNG


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Community Support Team
Community Support Team

Re: appending imported data in power query causes direct query error

hi,@vanessafvg

   This is likely happening because the composite models preview feature is turned on.you may try to disable other 

preview feature and try it again.

and the same issue has been reported internally before: CRI 79697545.

 

Reference:https://community.powerbi.com/t5/Issues/Power-Query-reports-about-noncompatible-DirectQuery-mode-for...

 

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.