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,

     

pjn's avatar
pjn
Frequent Visitor
9 years ago

I've just noticed that our dashboard has stopped refreshing since 16th January. All CSV files are stored in OneDrive for Business and accessed using Csv.Document(Web.Contents()). This has been working perfectly since end of last November and nobody has republished or changed settings since then.

 

Checking credentials showed that approx half of our oAuth2 data sources had 'lost' the credentials. Fixed these and tried again but refresh is still failing with the message "An unknown error has occurred. Please try again. If the issue continues, please contact support".

 

The company I'm doing this small dashboard for is rapidly losing faith in this solution. The project was almost scrapped back in November when there was an ongoing issue saving credentials (reported by a number of people in the community) that took a few weeks to be fully resolved. I'll be getting called back in tomorrow at my own expense to explain to them why I can't fix it, and will yet again have to defend Power BI as a suitable system for their usage.

 

EDIT: A few hours later and things seem to be working again now. Hopefully tomorrow's scheduled refresh will work as expected to save me a trip to this client's office.