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
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
Sorry for pasting wrong URL. Here is the correct URL
https://biib-my.sharepoint.com/:x:/r/personal/Pras_bose_Company_com/Documents/INT/SalesData.xlsx
With this url also, we are facing the same issue.
Not able to autehnticate datasource because for Web connection, Anonymous, Basic,& OAuth2 options are not working in Power BI/
In Power BI desktop, It is working with Organizational Account.
Thanks,
PBI V2
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