Forum Discussion
How to setup personal gateway for Office365 excel (OneDrive)
Hi Anonymous
The URL that you displaying, is this coming from how I & the video described how to get it? This is a very important step as it gives you the exact location of the file. But if it works in Desktop, then it should also work in the Service.
Within the Refresh settings of the report, have you edited the credentials also?
Thanks
Joe
Hello JoeBarry
Thank you so much for your help to resolve this issue. We tried a lot and finally resolved the issue
It was giving issue because of having ":x:/r/" in the URL.
Faulty URL - https://biib-my.sharepoint.com/:x:/r/personal/Pras_bose_Company_com/Documents/INT/SalesData.xlsx
Working URL - https://biib-my.sharepoint.com/personal/Pras_bose_Company_com/Documents/INT/SalesData.xlsx
Thanks,
PBI V2
Solution SageHi Anonymous
How did you connect to the excel? Are you using the Web connector or is it connected locally on your device?
If it's connected locally, then you will have issues. If you connect directly to OneDrive online, you don't need a Gateway.
Presuming that there is a Sync between your device's OneDrive and the cloud, to connect through the web connector. please do the following.
- Open the Excel app
- Go to file Under last used, you will see the file name. Right click and copy the file url
- Go to Power BI Desktop and choose the Web connector and paste the URL and remove the section below
- Click ok
There no need to set up a refresh as it will do it automatically when the report is opened.
Thanks
Joe
Hello JoeBarry
Thanks for your response
We are using Web Connector to comsume office365 excel which is available in OneDrive. We are able to refresh in Power BI Desktop as per your reply but we are not able to do the same when we deploy this report into my Workspace.
Thanks,
PBI V2
- JoeBarry
Here is great video with your secenario https://www.youtube.com/watch?v=CYSMZxaXNLk
The person looking to set up the refresh will need to have accesss to the file