- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Proud to be a Super User! |
|
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you for confirming that it is not possible.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Proud to be a Super User! |
|

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-19-2024 08:45 AM | |||
02-27-2023 01:29 PM | |||
05-30-2023 11:49 AM | |||
08-02-2024 11:49 AM | |||
08-21-2024 07:29 PM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |