Issue with connecting Excel shared on OneDrive

[Anonymous]

Hi everyone, I have been using OneDrive to store data and connect to PowerBI through web. This works fine even with Excel files that are not in my OneDrive but being shared to me. Recently, when I checked one of my report, the data in Excel file that is being shared to me (not in my One Drive but I have access and url link to it) is not working. Below is the picture of the message:

This is not an issue before so I wonder if the new update mess this up? Please suggest the solution because I don't want to migrate all the shared files to specific folder in One Drive. Thanks.

Duc

[Anonymous]

@Anonymous  - How did you connect with a document that was shared to you? I would like to do this as well but have been running into restrictions.  

thanks! 

[v-piga-msft]

Hi @Anonymous ,

For your requirement, please follow the steps in this official document.

If you still need help, feel free to ask.

Best  Regards,

Cherry

[Anonymous]

Hi Cherry,

Thank you for the response. Like I mentioned, I have been using this method for a long-time and there's no problem with this. Recently, when I am opening up a PowerBI desktop file to make some adjustment this connection (which works before) is no longer working. I am sure I do it correctly because it works for over a year, the message in the picture is what I see. I also try to redo this from scratch (similar to the documentation you sent) and it still shows me the message. I tried this with other file being shared to me (not in my One DRive) and they have same issues. That is why I was thinking that this way doesn't work with shared file anymore. It still works when I connect to a file on my One Drive. Thanks.

Duc

[v-piga-msft]

Hi @Anonymous ,

By my research and tests, I have a little confused about how do you connect the shared OneDrive Excel.

If it is convenient, could you share the details steps?

In addition, please try the ways below which may be helpful.

1. Please check if you have installed the latest version of Power BI Desktop 2.69.5467.2151.

2. Clear the permission and connect it again.

3. In addition, please check if the excel you want to connect has been removed in the OneDrive. You could get the link again and have a try.

By my tests, if I remove the excel in OneDrive, I will get the same issue as you upload in your first post.

Best  Regards,

Cherry