You have a Power BI semantic model that contains a table named Table1. Table1 runs in Import storage mode. You need to update the model to change the storage mode of Table1 to DirectQuery. What…

The correct answer is A. Delete Table1, and then add the table to the model again in DirectQuery storage mode. To switch a table's storage mode in a Power BI semantic model from Import to DirectQuery, you can't directly change it from Import to DirectQuery. Instead, you'll need to rebuild the model, potentially creating a new DirectQuery-based table and then copying the transformation…

Submitted by zhang_li· Apr 18, 2026

Question

You have a Power BI semantic model that contains a table named Table1. Table1 runs in Import storage mode. You need to update the model to change the storage mode of Table1 to DirectQuery. What should you do?

Options

ADelete Table1, and then add the table to the model again in DirectQuery storage mode.
BFrom Power Query Editor, duplicate the query for Table1.
CFrom Model view, change the storage mode of Table1 to DirectQuery.
DAdd an aggregation table to the model.

How the community answered

(51 responses)

A
84% (43)
B
4% (2)
C
2% (1)
D
10% (5)

Explanation

To switch a table's storage mode in a Power BI semantic model from Import to DirectQuery, you can't directly change it from Import to DirectQuery. Instead, you'll need to rebuild the model, potentially creating a new DirectQuery-based table and then copying the transformation steps from your original Import table. Alternatively, you can use a calculated table based on the original DirectQuery table and use that for relationships and visuals. https://community.fabric.microsoft.com/t5/Desktop/Direct-Query-and-Enterprise-migrating-from- import/m-p/11922#M2728

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice