Reply
LuigiBros
Frequent Visitor
Partially syndicated - Outbound

Append of 2 tables with DQ

I have 2 tables, one is in import mode, second is in direct query.

When I append them PBI automatically changes append table to import mode.

I tried to change this mode in model view in properties but it is greyed out.

Is there a way to append both tables in direct query mode?

1 ACCEPTED SOLUTION
bhanu_gautam
Super User
Super User

Syndicated - Outbound

@LuigiBros , 

 

In Power BI, when you append tables, the resulting table inherits the storage mode of the tables involved. If one of the tables is in Import mode, the resulting table will also be in Import mode. This is why you are seeing the append table automatically change to Import mode.

Unfortunately, Power BI does not support appending tables where one is in Import mode and the other is in DirectQuery mode while keeping the resulting table in DirectQuery mode. Both tables need to be in DirectQuery mode for the resulting table to also be in DirectQuery mode.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

2 REPLIES 2
LuigiBros
Frequent Visitor

Syndicated - Outbound

Thank you for confirming that it is not possible.

bhanu_gautam
Super User
Super User

Syndicated - Outbound

@LuigiBros , 

 

In Power BI, when you append tables, the resulting table inherits the storage mode of the tables involved. If one of the tables is in Import mode, the resulting table will also be in Import mode. This is why you are seeing the append table automatically change to Import mode.

Unfortunately, Power BI does not support appending tables where one is in Import mode and the other is in DirectQuery mode while keeping the resulting table in DirectQuery mode. Both tables need to be in DirectQuery mode for the resulting table to also be in DirectQuery mode.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)