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 App2. When excel open, go to File, then Copy link to clipboard3. In Power BI Desktop, Get Data -> Web, paste the copied information into URL4. 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

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.

Forum Discussion

Regular Visitor

4 years ago

Solved

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