Forum Discussion

geoffballard's avatar
geoffballard
New Member
8 years ago
Solved

Directly Query for SQL Server not working on Power BI Report Server

I having an issue getting direct query mode working for SQL Server on Power BI Report Server (August 2017 Preview) My query is really simple "SELECT data, u from GBT3". The table has 2 rows If I crea...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi geoffballard,

     

    It's a limitation now, you can see here: 

     

    • DirectQuery data connections are not currently supported.

     

    Best Regards,

    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi geoffballard,

 

It's a limitation now, you can see here: 

 

  • DirectQuery data connections are not currently supported.

 

Best Regards,

Qiuyun Yu 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello 

     

    I have the same issue.

     

    What is the solution please?