Forum Discussion
Error message while retrieving data from one drive
- 5 years ago
Hi shivar
Please refer this related post and try the method:
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hello All,
I am trying to chanage the source of excel file. The excel file was on local and now is saved to onedrive. i am trying to change the source setting but unbale to do so. The following error message is showing when i put the location path copiend from the file.
The File path was copied from the excel 365 app.
Can anyone help me out in this?
Thanks,
Shiva R
shivar , onedrive you have use like web source
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Create a new one connection using one drive and then open advance editor in power query for that table and replace above portion
Part of steps are shown in