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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

A SQL Server 2016 database

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft 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