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: 

 

Something went wrong
Unable to load the model
Please try again later or contact support. If you contact support, please provide these details.
Request ID03f76e0f-0164-ab35-a42b-2ccdb7109b1f
TimeMon Oct 16 2017 11:35:21 GMT+1300 (New Zealand Daylight Time)
Version14.0.600.379

 

Will it be enabled in the next GA release?

 

Jaco

August Preview
DirectQuery

5 Replies

  • 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