Forum Discussion

andreucci's avatar
andreucci
Frequent Visitor
9 years ago

Office 365 credentials refused when setting up data refresh in Power BI

I have a weird problem that started today: I can't seem to make credentials stick when I setup new datasets for automatic refresh.   My models are usually connected to Excel, CSV or Text files on O...
Need Help
colderub's avatar
colderub
Frequent Visitor
9 years ago

Hi,

 

I believe I have the same problem you describe. I have published a number of reports from Power BI Desktop using excel files stored on OneDrive for Business. I was able to schedule a refresh of these datasets using my OneDrive credentials.

 

This worked flawlessly until approxamitely a week ago. Now when I upload a report/dataset I cannot get it refresh, it seems like my credentials are not being updated.

 

Previous datasets are still updating though.

 

Please let me know how you get on with Microsoft...

 

/Derek

andreucci's avatar
andreucci
Frequent Visitor
9 years ago

Thanks Derek,

you describe a scenario identical to mine.

 

  • New datasets pulling data from Excel file(s), stored on OneDrive for Business, using Web.Contents() refuse valid credentials when updating
  • Old datasets in the same exact situation still refresh with no hiccups.

 

I think reporting your experience might be valuable for Microsoft, thanks for sharing.

 

[EDIT: you should follow this discussion on answers.microsoft.com, here the Microsoft Team will report about my issue. As you see this seems to involve my entire account, I am experiencing other weird symptoms with account provisioning and Office 365. Feel free to reply there as well making them aware of your issue).

 

Andrea