Forum Discussion
onedrive refreshWITHOUT gateway
jmdh A couple things:
You are correct, if the Excel file is stand alone in the One Drive it does not need a gateway, because you aren't refreshing any data in the file from an on premises source.
To your previous post:
When you reference the Excel file in the One Drive location you need to use the external facing link. Details here
Thank a lot: this is the first time that i can have a refresh working without a gateway as it should.
The link you sent was very useful since i had tried using a Onedrive link before as a source of data , but without success, when with your link it was a pleasure.
So i am left with : can automatic refreshes work when i use the same data file in PowerBI Desktop , but i access it with Get Data Excel insteadof Get Data Web (that has never worked for me)
jmdh I guess I don't understand the question. The link I provided was for the Desktop, it should work either way...