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.
highlander25361 had a smiliar issue last week. Make sure your data source is online (check it on manage gateway page in power bi service)
If its offline consider re-installing your gateway.
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.
Hi, I just faced with the same problem. I am trying to get the excel data from Onedrive. I started get data => web connector => copied the path/URL and pushed OK and got the following message. No credential asked for.
Is there any reason it is not getting through?
Thanks
Hi, Not sure how it will work from OneDrive as the YouTube video is for accessign the file from a SharePoint document library. It might work though, you need to open the excel file in the desktop app and then click on File and Info then copy path. Delete the ?web=1 from the end of the filename. You then use that URL as URL for the web connector
Thanks for your answer. I did exactly as proposed, opened in desktop => copied the path into the requested URL, no ?web=1 at the end of the path copied
And I think OneDrive and SharePoint should not have difference on that sense.
I am tying still resolve this but also web conector is not working with public web source as well like List of countries by GDP (nominal) per capita - Wikipedia
