Hi,
The scenario....
I have two Servers (Server 1 and Server 2), each running the latest version of the On-Premises Data Gateway. Server 1 and Server 2 are configured exactly the same. Server 2 is just a failover for Server 1.
In our Power BI Service account we have three sets of Power BI reports. Two set use an ODBC connection to Hadoop data. These two sets of reports, using Server 1 Gateway, execute and complete their data refreshes fine. However, the other set uses a SQL Server connection to an on-site SQL Server database.
The odd thing here is....
I was notified of the need to upgrade our Gateway software by the 15th March 2018. I upgraded this software to version 14.16.6584.1 I understand this to still be the latest version. I upgraded this Gateway in JANUARY. Straight after the upgrade I tested all reports and each refreshed successfully.
The SQL Server sourced reports are scheduled to refresh 8 times each day. On Saturday 10th Feb '18, the 13:00 refreshed executed and completed successfully (as did all refreshes before then). The very next attempt at 15:00 (on the same day) failed. Each attempt since then has failed too. Strangly, the Hadoop sourced Power BI reports using the same Gateway are continuing to refresh successfully. Why is the SQL Server sourced Power BI reports failing???
The error message just says "Cannot connect to the mashup data source. See error details for more information." Then it just shows the standard Cluster URL, Activity ID, Request ID, and Time infomation.
I have tried the reports using Gateway Server 2 and it fails just like when using Gateway Server 1.
I have used SSMS to connect directly to the SQL Server database, used as the source, and queried the data. I was able to do this successfully. So I know the source is active and responsive.
There is not Personal gateways installed on either Gateway and neither the Power BI Service account.
Has anyone else experience this? Does anyone has any suggestion to what to do to resolved this?
Thanks in advance.
