topic Re: Direct Query from SQL Server Data Source on October Release of Report Server in Report Server

Direct Query from SQL Server Data Source on October Release of Report Server

jbarker — Fri, 03 Nov 2017 12:55:26 GMT

Trying a direct query mode report from a browser render using a sql server data source gets the error "We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.".

Re: Direct Query from SQL Server Data Source on October Release of Report Server

v-qiuyu-msft — Mon, 06 Nov 2017 02:39:14 GMT

Hi @jbarker,

If you create a new report then publish to Power BI report server October version, please follow the suggestion in this thread: http://community.powerbi.com/t5/Report-Server/PowerBI-Server-October-DirectQuery-to-SQL-Server-table-bug/td-p/295515

If the report exists before upgrade to Power BI report server October version, please see this thread: http://community.powerbi.com/t5/Issues/Existing-Power-BI-reports-will-not-load-after-upgrading-to/idi-p/295266

Best Regards,
Qiuyun Yu

Re: Direct Query from SQL Server Data Source on October Release of Report Server

jbarker — Mon, 06 Nov 2017 13:56:17 GMT

This worked, it was losing credentials.

Re: Direct Query from SQL Server Data Source on October Release of Report Server

v-qiuyu-msft — Tue, 07 Nov 2017 01:23:28 GMT

Hi @jbarker,

Thanks for your update. 🙂

As the issue is fixed now, I will close this thread.

Best Regards,
Qiuyun Yu

Re: Direct Query from SQL Server Data Source on October Release of Report Server

dhawal16 — Fri, 18 May 2018 17:16:15 GMT

I am facing the same while using Excel as a Datasource with Import on Power BI Report Server. Again it is not everytime but its intermittent

Any pointers will be helpfull.

Cheers,

Dhawal