Power storage mode

What is storage mode in Power BI?

In Power BI, Storage mode is a property that you can set on each table in your model to control how Power BI caches the table data. To set or view the Storage mode property, select the table in Model view.

What is dual storage mode in Power BI?

Go to Solution. 12-19-2024 11:51 PM Hi @powerbiexpert22 , In Power BI, the Dual Storage Mode is one of three storage modes (alongside Import and DirectQuery). Dual mode allows a table to act as both Import and DirectQuery, depending on the context in which the table is used.

How do I set the storage mode property?

To set the Storage mode property in Power BI Desktop, follow these steps: In Model view, select the table, then in the Properties pane, expand the Advanced section, and expand the Storage mode drop-down. You can set the Storage mode property to one of these three values: Import, DirectQuery, or Dual.

How do I change the storage mode?

To change the storage mode, right-click on the table, select 'Properties', and then choose the desired mode for that specific table.

Can I change the storage mode of a table to import?

Changing the Storage mode of a table from Import to something else is an irreversible operation. After this property is set, it can't later be changed to either DirectQuery or Dual. You can use Dual storage mode in both Power BI Desktop and the Power BI service.

What does Power BI cache with storage mode?

The Storage mode property controls how Power BI caches the table data. To set the Storage mode property, or view its current setting: In Model view, select the table whose properties you want to view or set.