Forum Discussion
Refresh doesn't work in Service on Excel file in Sharepoint
Super UserHi LHDatalis
If changes in the SharePoint Excel file aren't showing up in Power BI Service after a manual refresh:
- Check OAuth2 credentials: Ensure they’re correctly set and reauthenticate if expired.
- Verify SharePoint URL: Ensure the URL is correct and consistent between Power BI Desktop and Service.
- Permissions: Ensure the Power BI Service has access to the SharePoint file.
- Clear Cache: In Power BI Service, clear cache and refresh the dataset.
- Check Scheduled Refresh: Make sure it's set up and hasn't failed.
- Check Refresh Logs: Look for any errors in the refresh logs.
- File Locking: Ensure the SharePoint file isn’t locked or being edited.
These steps should help resolve the issue and ensure updates reflect in Power BI Service.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Thanks Anonymous Poojara_D12 Ajithkumar_P_05 for your answers.
I think it costs a little rendering time to see a adjusment in the Excel file.
When I use a scheduled refresh every morning, the adjustments in the Excel are present in the Power BI report.
When I make a adjustment in the Excel file and refresh the report by hand in Power BI service, the adjustment is not present in de Power BI report.
I'm glad the scheduled refresh is working, but would have prefered a working manual refresh as well.