Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

PowerBI Report Server (August Preview) and DirectQuery in PowerBI reports

Hi   Does the "DirectQuery" connectivity mode (to a sql server database) work for powerbi reports? It works when on PowerBI Desktop (report server) but as soon as it is published it fails with:   ...
August Preview
DirectQuery
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Please refer to Jon-Heide's reply here.

     

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Power BI Report Server August Preview doesn't support DirectQuery data connections, apart from Analysis Services live connections.

 

Please see this article: Connecting to data sources

 

Best regards,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Yuliana

 

Will it be supported in the next GA release?

 

Regards,

Jaco

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    Please refer to Jon-Heide's reply here.

     

    Regards,
    Yuliana Gu