Forum Discussion

curtismob's avatar
curtismob
Helper IV
8 years ago
Solved

SQL On-Prem with Enterprise Gateway refresh issue

I have an on-prem data gateway dataset refresh that was automatically disabled.  The dataset is SQL server and has been working for months.  I cannot re-enable, because the on-prem data gateway option is grayed out.

 

Thank you in advance,

curtismob

Need Help
  • curtismob's avatar
    curtismob
    8 years ago

    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,

    curtismob

8 Replies

  • rjhale's avatar
    rjhale
    Helper V
    8 years ago

    I have a few reports that have scheduled refreshes against an on-prem Oracle datasource.  Everyone of those scheduled refreshes failed this morning, and I am unable to refresh the datasets on-demand in the service currently.  The data gateway is functioning as expected, and all of the data sources test without issue.  These reports have been refreshing on a daily basis for months without any problems until this morning.    

    • GilbertQ's avatar
      GilbertQ
      Super User
      8 years ago

      Hi there

       

      There are the following issues with the Power BI Service at the moment which might be affecting your issues.

       

      • rjhale's avatar
        rjhale
        Helper V
        8 years ago

        The service health page no longer has any information about scheduled data refresh failures.  My reports are still failing even though the data gateway is healthy, and I'm not finding anything that stands out in the log files.  I'm seeing really generic errors in the service that look like this with 15+ scheduled data refreshes:

         

        Failed Connections:Query - Get Award Exceptions
        Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
        Activity ID:e8c3cc55-01e2-4f85-647a-60d8643ac60f
        Request ID:a79a6fd5-f59b-61d1-2a16-2bd8c6f098a1
        Time:

        2018-05-14 14:25:15Z

         

        I went as far as reinstalling the data gateway (I only have one machine with the enterprise gateway installed) and republishing several of my reports.  The on-demand refreshes would typically complete a refresh successfully the first time, but now they are right back to failing with the generic errors as posted above.  This is becoming a very big problem for us as this is now day 4 of all our scheduled processes being down.  

         

        Is there a known issue with the service?  Any other suggestions for correcting the failed refreshes?