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

[Anonymous]

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

[Greg_Deckler]

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

[Anonymous]

A SQL Server 2016 database

[v-yulgu-msft]

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]

Hi Yuliana

Will it be supported in the next GA release?

Regards,

Jaco

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Please refer to Jon-Heide's reply here.

Regards,
Yuliana Gu