Forum Discussion

maracles's avatar
maracles
Resolver II
10 years ago
Solved

Refresh Now and Scheduled Refresh Not Working

We have been using Power BI for several months now and have used Scheduled Refresh with very few issues. However the last week we have been experience increasing issues, and then today we cannot upda...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    maracles

     

    In this secnario, I suggest you check the logs first.

    You can see On-premises data gateway service logs under: 

    C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log

    And On-premises data gateway service event logs  under Application and Services Logs.

     

    Then please restart enterprise gateway service via command:

    net stop PBIEgwService

    net start PBIEgwService

     

    If the issue still persists, I suggest you uninstall Enterprise gateway and install latest version On-premises data gateway. For more details, please see: Troubleshooting the On-Premises Data Gateway

     

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

maracles

 

In this secnario, I suggest you check the logs first.

You can see On-premises data gateway service logs under: 

C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log

And On-premises data gateway service event logs  under Application and Services Logs.

 

Then please restart enterprise gateway service via command:

net stop PBIEgwService

net start PBIEgwService

 

If the issue still persists, I suggest you uninstall Enterprise gateway and install latest version On-premises data gateway. For more details, please see: Troubleshooting the On-Premises Data Gateway

 

Regards,

 

  • maracles's avatar
    maracles
    Resolver II
    10 years ago

    v-sihou-msft Thank you for the suggestion. This actually seemed to resolve itself however what you recommend is useful to now in future.

  • VigneshVs's avatar
    VigneshVs
    Frequent Visitor
    9 years ago

    v-sihou-msft

     

    We have an enterprise gateway installed and the schedule refresh was happening successfully.

    However we are experiencing the above issue right now 

    with these concerns 

    1.log is empty(for the current day, last logged previous day when refresh happened)

    2.Services were restarted

    3.Latest Enterprise gateway installed.

     

    Still issue persists...

     

    Any help would be greatly appreciated

     

    Thanks,

    Vignesh

     

     

    • RiddermarkBil's avatar
      RiddermarkBil
      Regular Visitor
      9 years ago

      Have the exact same Scenario. Have 15 datasets and none have refreshed since 15hrs ago.

      The "next scheduled refresh" is 5 hours ago and that usually changes for later (like if microsofts clock is off)

      Everything refreshed through on premises before but installed a gateway just to try but to no change.

      One of the datasets is googe analytics and on that set it sais the credentials anr wrong but they´re not.

      Feels like the problem is on Microsofts end..

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        We have the same issue with SQL Database Data Sources. The Refresh Now button is not working. This seems like a Microsft side issue...