Get Data\Web\Ondrive\Sharepoint - What link should I use?

[Mbryant]

Hi All,

I've been trying to setup Power BI Desktop to connect to an excel file on my Onedrive (Business). But I've had all sorts pof issues.  Can't do ti through Sharepoint either.  Can someone clarify exactly what link I should be using please?

I'm doing it through get Data\ Web.  Feels liek I've got hte worong link.  Found this:  

http://www.sensdat.com/publications/onedrivefilepowerbidesktop/

But the link described there is not showing for me.  Any definitive explanation of how I shold be doing this would be much appreciated.

Thanks.

MArtin.

[v-yuezhe-msft · Accepted solution]

@Mbryant,

Please take a look at the following article about how to get the link of Excel file stored in OneDrive for business.

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

Regards,
Lydia

[Mbryant]

Hi,

I'm trying to connect to an Excel file on either sharepoint or onedrive, but I'm getitng all sort of errors.  I think I'm using the worng link.

I foumd this but the link described here is not showing for me.

http://www.sensdat.com/publications/onedrivefilepowerbidesktop/

Can somene clarify what link IU shoud be using.  Preferably for Onedrive for business.  

Thanks.

Martin.