Forum Discussion

pycon9's avatar
pycon9
New Member
10 years ago
Solved

How can I switch the connection setting from Import to DirectQuery

I have an existing Power BI Desktop file with a query that pulls data from a SQL Server using the 'Import' option. How can I switch it to use the 'DirectQuery' option? So far it looks like my only op...
Need Help
  • pqian's avatar
    pqian
    10 years ago

    Hi,

     

    Due to the current restrictions on DirectQuery (lack support for measures, calculations, BiDirection relationships, etc), models that are created in Import mode cannot be switched into DirectQuery mode. So for now, your only option is to create the model from scratch and always stay in DirectQuery mode.

     

    Regards,

    PQ

pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi,

 

Due to the current restrictions on DirectQuery (lack support for measures, calculations, BiDirection relationships, etc), models that are created in Import mode cannot be switched into DirectQuery mode. So for now, your only option is to create the model from scratch and always stay in DirectQuery mode.

 

Regards,

PQ