Forum Discussion

mohittimpus's avatar
mohittimpus
Helper V
6 years ago

One Drive Connection give the error message.

I have connect to power BI with One Drive json file. For this I am using Web connection in Power BI dekstop.   Below Link I am using: https://americanhighschool-my.sharepoint.com/personal/develope...
Need Help
mohittimpus's avatar
mohittimpus
Helper V
6 years ago

Hi v-lili6-msft ,

We are using the same password which we are using to connect the one drive file in Power BI desktop, the same credentials I'm using for Power BI Service and also have selected organizational account but still It's give the error message.

 

Thanks,

mohitimpus  

mohittimpus's avatar
mohittimpus
Helper V
6 years ago

v-lili6-msft 

 

Currently there is NO way to set up a scheduled refresh, if your file is on ONE DRIVE, or SHARE POINT, where you need to login using the "Organisational Account" credentials option. 

 

It will work in PowerBI Desktop, but as soon as you publish from there to PowerBI online, when you try to set up a scheduled refresh you will get the following error:

 

"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."

 

If you from there try to edit the credentials, the only options you will have are:

 

- Anonymous

- Windows

- Basic

 

Unlike PowerBI Desktop, no "Organisational Account" option!

 

This is basic functionality that should ought to really have been fixed a while ago!