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-p/243956

 

We have a report that was created with a live connection to Azure Analysis Service, but we want to share it with folks who do not have direct access to that data cube, which won't work with a live connection obviously.

 

The option to make changes to the data model prompts to change it to a Direct Query, but it's the same scenario:  In the data view, clicking on a table and going to advanced properties, storage mode shows "Direct Query" but it is greyed out.

 

Is there any way to convert the Live Connection model (or Direct Query) to an import or do we just start over and rebuilt the same report?

 

Thanks!

Dataflow
Need Help

1 Reply

  • 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.