Forum Discussion
SQL On-Prem with Enterprise Gateway refresh issue
Hello,
I resolved my original issue. I added a new IBM DB2 table to my dataset, so after publishing and since I didn't have a related source configured in my on-prem data gateway, it would not allow me to schedule a refresh. Once I added the IBM DB2 data source to the on-prem data gateway, I was able to schedule my refresh again.
As far as some of the other issues some of you have reported, we recently experienced some refresh failures that were due to firewall firmware updates, because of the continued need for stronger security. Our security team had to make a firewall change to fix the refresh issue.
Thanks,
Hello,
I resolved my original issue. I added a new IBM DB2 table to my dataset, so after publishing and since I didn't have a related source configured in my on-prem data gateway, it would not allow me to schedule a refresh. Once I added the IBM DB2 data source to the on-prem data gateway, I was able to schedule my refresh again.
As far as some of the other issues some of you have reported, we recently experienced some refresh failures that were due to firewall firmware updates, because of the continued need for stronger security. Our security team had to make a firewall change to fix the refresh issue.
Thanks,
Both Schedule and on demand refreshes for Excel Workbooks are failings since saturday 05/12/2018
Is anyone facing these issues?
Although Power BI refreshes are working fine and the gateway does not log any message either.
Below is the message which I am getting, it is not at all descriptive.
Scheduled 5/14/2018, 9:31:06 AM 5/14/2018, 9:34:21 AM Failed Workbook refresh failed. See details for more information.
Failed Connections: XXXX
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 89899023-b67d-480b-a29c-de10c2e1aacc