Forum Discussion
Scheduled Refresh
I managed to resolve the sync by changing the connection from the direct excel file to using the http address to the SharePoint file. https://www.youtube.com/watch?v=DWG0uvgg5nM
Once published again, it allowed me to use auth2 authentication and set up the scheduler.
Here are a few things you can try to troubleshoot the issue:
Make sure that you have the correct permissions to access the Excel file on SharePoint Online. You will need at least read permissions to be able to refresh the data in Power BI.
Check the privacy level settings for the data source. In Power BI, go to the "Data Source Credentials" page for the dataset and make sure the privacy level is set to "Organizational" or "Public". If the privacy level is set to "Private", Power BI will not be able to access the data when it is published to the service.
Make sure that the Excel file is not open in another application. Power BI will not be able to refresh the data if the file is open in another program such as Excel or a browser.
Try refreshing the data in Power BI Desktop. If the data refreshes successfully in Power BI Desktop but not in the service, there may be an issue with the connection to the data source in the service. In this case, you may need to re-publish the report to the service with a new connection to the data source.
Thanks DataSlayer for the suggestions. Sadly none of them worked. Ive got edit access to the spreadsheet. Cleared and reset the credentials to Organisational including anyglobal permissions to other areas of the same site. Republished the report but its still thinking theres no valid credentails so wont schedule refresh.