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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

What is your data source? It was orginally released just with live connectivity to SSAS.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

A SQL Server 2016 database

  • 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