Cannot open excel from OneDrive

[testvolt]

Hi guys,

I cannot open my excel file for OneDrive, is it only for OneDrive for Business ?

I follow this step:

1. From my Onedrive, right click -> Open In App

2. When excel open, go to File, then Copy link to clipboard

3. In Power BI Desktop, Get Data -> Web, paste the copied information into URL

4. Remove the last parameter up until .xlsx

It always return error saying ->

Same goes when I'm using Basic ant type again my user id which is same as my OneDrive (and my current login in Power BI desktop) ->

Thanks

[PaulDBrown]

Try using the Windows option to enter your credentials

[testvolt]

Hi,

The login / email id is from Microsoft when request trial, I don't think there is a domain for me to key in. Or in other word, I don't know what to key in that widows user name, if I choose Current credential, it will be the same error.

Thanks

[PaulDBrown]

I mean try logging in using the Windows option instead if basic or organizational account

 

[testvolt · Accepted solution]

Hi @PaulDBrown 

Yes, that is what I referring to as well. But is ok now. Turns out we must use Organization Account instead.

Solved. Thanks.