Unable to connect to oneDrive for Business

[bi_kwoksanlee]

Hellow everyone, 

I have a excel file in my oneDrive for Business and I would like to use that excel file as the data source of my Power BI Report.   In the data source settings, I have already set up the permission to my oneDrive [https://hutchisonports-my.sharepoint.com/personal/xxxxxx]

I have followed the below steps to connect the exce file

(1) Get Data>Web

(2) input the URL of excel file [https://hutchisonports-my.sharepoint.com/personal/xxx/Documents/folder1/excel.xls] 

(3) Select Windows and use my Windows credentails to access the Web content

However the below error is shown

"We're unable to connect.   Please delete your credentaials and try again".

Thanks in advance for the help,

[bi_kwoksanlee · Accepted solution]

Hello All,

The problem is solved after I installed a new version of Power BI Desktop.  Thank you for the help!

[amitchandak]

@bi_kwoksanlee , First try this.

file-> Options and settings -> Data source setting -> select datasource and clear permissions

Also, refer to this doc on how to connect

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

[bi_kwoksanlee]

I have tried to clear permission in Data source settings.   However I am still unable to connect to my OneDrive for business.