Forum Discussion

highlander25361's avatar
highlander25361
Regular Visitor
3 years ago
Solved

Scheduled Refresh

I have an shared excel document stored on SharePoint online which I have created a report from PowerBI Desktop.  I can refresh the data successfully in desktop. The problem is that once I have publis...
Need Help
  • highlander25361's avatar
    highlander25361
    3 years ago

    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's avatar
highlander25361
Regular Visitor
3 years ago

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  

PowerZs's avatar
PowerZs
Regular Visitor
3 years ago

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