Forum Discussion
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...
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
