Error message while retrieving data from one drive

[shivar]

Hello All,

Following is the error message which i am recieving when i connect the excel file from the onedrive(personal).

I need to get the solution of this,

Can anyone help me on this

Thanks

[shivar]

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

[v-xulin-mstf]

Hi @shivar,

I noticed that you mentioned a similar post in another thread.

If the issue has been solved, please adopt the solution to help others.

If you still have some question, please don't hesitate to let me known.‌‌

😉

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!

[amitchandak]

@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

https://www.youtube.com/watch?v=59PUFuuCrbY

[v-xulin-mstf · Accepted solution]

Hi @shivar

Please refer this related post and try the method:

https://community.powerbi.com/t5/Power-Query/PowerBI-support-for-OneDrive-Personal-as-data-source/m-...

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!

[amitchandak]

@shivar , Have you taken the link after opening it in excel. check this document

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links