topic Re: PowerBI Report Server (August Preview) and DirectQuery in PowerBI reports in Report Server

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

Anonymous — Mon, 16 Oct 2017 00:18:59 GMT

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

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

Greg_Deckler — Mon, 16 Oct 2017 00:11:32 GMT

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

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

Anonymous — Mon, 16 Oct 2017 00:16:06 GMT

A SQL Server 2016 database

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

v-yulgu-msft — Mon, 16 Oct 2017 02:32:11 GMT

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

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

Anonymous — Mon, 16 Oct 2017 02:38:44 GMT

Hi Yuliana

Will it be supported in the next GA release?

Regards,

Jaco

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

v-yulgu-msft — Mon, 23 Oct 2017 09:26:11 GMT

Hi Anonymous,

Please refer to Jon-Heide's reply here.

Regards,
Yuliana Gu