Forum Discussion

tbakrf's avatar
tbakrf
Frequent Visitor
3 years ago
Solved

Convert Power BI model from Live Connection to Import

I know the opposite question was posed here a while back (with no as the answer): https://community.fabric.microsoft.com/t5/Desktop/converting-power-bi-model-from-imported-mode-to-live-connection/m-...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi tbakrf ,

     

    Switching from live connection to import mode is not currently supported.
    To switch from direct query mode to import mode, select "Model View" in the left pane of Power bi desktop, use the "DirectQuery" storage mode to select the appropriate table, go to "Properties" and change the storage mode.

     

    Please be aware of these restrictions:

    Use storage mode in Power BI Desktop - Power BI | Microsoft Learn

    DirectQuery in Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Neeko Tang

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi tbakrf ,

 

Switching from live connection to import mode is not currently supported.
To switch from direct query mode to import mode, select "Model View" in the left pane of Power bi desktop, use the "DirectQuery" storage mode to select the appropriate table, go to "Properties" and change the storage mode.

 

Please be aware of these restrictions:

Use storage mode in Power BI Desktop - Power BI | Microsoft Learn

DirectQuery in Power BI - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

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