Forum Discussion

TheKiltedGolfer's avatar
TheKiltedGolfer
Icon for Helper III rankHelper III
7 years ago
Solved

This query contains transformations that cannot be used in DirectQuery

Has anyone found a solution for the above issue yet?  It seems there is no definitive answer.  I am getting data/connecting to a SQL server just fine.  I enter a single and simple SQL statement, whic...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi TheKiltedGolfer,

    Based on my test, it could work on my side:

    After you have deselected the "Composite Models" feature under "Preview features" , could you have closed your Power BI Desktop and try to reopen it to get data for your SQL Server?

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi TheKiltedGolfer,

Based on my test, it could work on my side:

After you have deselected the "Composite Models" feature under "Preview features" , could you have closed your Power BI Desktop and try to reopen it to get data for your SQL Server?

 

Regards,

Daniel He