Forum Discussion

reemelshenawy's avatar
reemelshenawy
Frequent Visitor
4 years ago

How to Switch mode in PowerBI from import to Direct or vice versa

I created reports based on my SQL Server DB with the "Import" option, Now I want to switch all the reports into the "Direct Query" option, so is any solution or workaround for that to switch this thing immediately.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    reemelshenawy , Direct query to import is possible. In the data model view, in the property pane, you have an option for that.

     

    Vise versa is not possible. Add tables again as direct query and rebuild model .

     

    To save measure we use to remove the table in power query and add it with the same name(direct query) . But all calculated dax columns will go away. Also, Dax rename. Power Query rename you can adjust by looking at import code