cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mshparber Established Member
Established Member

Connect to shared Excel file in OneDrive for Business with "guest link" (Anonymous Authentication)

Hello friends,

I have a simple shared Excel file on OneDrive for Business (shared with anyone = "guest link")
I want to import it as a source with my query.

When I do this:

= Excel.Workbook(Web.Contents("https://team8industrial-my.sharepoint.com/personal/michaelshparber_team8industrial_onmicrosoft_com/_..."), null, true)

I get error message:

DataFormat.Error: The input URL is invalid. Please provide a URL to the file path on SharePoint up to the file name only (with no query or fragment part).

Maybe I can alter the link somehow?

Please help

Thank you

Michael

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Connect to shared Excel file in OneDrive for Business with "guest link" (Anonymous Aut

Hi @mshparber,

Do you connect to Excel file on OneDrive for Business in Power BI Desktop using Anonymous option? If that is the case, I get the following error message when using Anonymous option. As stated in this article, we need to use Organizational Account (for Office 365 or OneDrive for Business sites) when connecting to files on OneDrvice for Business.
1.png

However, it is possible to connect to Excel file on OneDrive for personal in Power BI Desktop using Anonymous option.

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Super User
Super User

Re: Connect to shared Excel file in OneDrive for Business with "guest link" (Anonymous Aut

Read my article here.  It describes how to connect Power BI to one drive files  http://exceleratorbi.com.au/data-modelling-onedrive-source-files/ 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
mshparber Established Member
Established Member

Re: Connect to shared Excel file in OneDrive for Business with "guest link" (Anonymous Aut

Great Article!

While it's working fantastic with OAuth2 - it doesn't work with "guest link"

The Url needs some other stucture...

?

Thanks!

Michael

Highlighted
Super User
Super User

Re: Connect to shared Excel file in OneDrive for Business with "guest link" (Anonymous Aut

I haven't tested this, but my assumption is you own the file and hence you should be able to make a secure connection to the file. The guest link is just a way for other to connect to the file.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Moderator v-yuezhe-msft
Moderator

Re: Connect to shared Excel file in OneDrive for Business with "guest link" (Anonymous Aut

Hi @mshparber,

Do you connect to Excel file on OneDrive for Business in Power BI Desktop using Anonymous option? If that is the case, I get the following error message when using Anonymous option. As stated in this article, we need to use Organizational Account (for Office 365 or OneDrive for Business sites) when connecting to files on OneDrvice for Business.
1.png

However, it is possible to connect to Excel file on OneDrive for personal in Power BI Desktop using Anonymous option.

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mshparber Established Member
Established Member

Re: Connect to shared Excel file in OneDrive for Business with "guest link" (Anonymous Aut

Thanks Lydia,

So I understand it's just not possible, even if the file is shared publicly with everyone as a "guest link".

Strange, but if  so - I'll search for another storage option.

Thanks again for the reply.

Michael

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 403 members 4,035 guests
Please welcome our newest community members: