Forum Discussion
Office 365 credentials refused when setting up data refresh in Power BI
I just tried to get data from OneDrive Business using Web.Conetents() and I can schedule refresh with OAuth2 properly.
Have you tried to click “Edit credentials” and input your OneDrive credentials again? Does the refresh works well in PBI Desktop?
BTW, I noticed that there is a notice in the Power BI Support site. It is related to refresh failures with gateway connecting to on prem data sources. Not sure if it also has effect on refresh without gateways. You can try it later to see if your issue persists.
Some Power BI customers in North Europe are experiencing data refresh failures with gateway connecting to on prem data sources. Engineers have identified the root cause of the issue and are working on a fix. Next update 11/23/2016 @ 18:00 PST.
Best Regards,
Herbert
Thanks Herbert,
my scenario is different from the one you have reported about.
Unfortunately I think this problem is related to some degradation of my account, I am looking into it with Microsoft in order to fix several problems.
This is not an On premise scenario, i connect to Excel file stored on OneDrive for Businees, so it's completely cloud. Also, all the datasets created and setup for refresh before the incident still work and update flawlessly.
I still don't know what happened and I hope to fix the issue soon.
If other encountered this problem, feel free to reply.
Thanks,
Andrea
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
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
I think I can repro the same issue as you. In Power BI Desktop, I get data from a excel file on OneDrive for Business with the steps in this official document. After I publish it to Power BI Service, I try to change the data source credential to OAuth2. Everything looks fine until now. But once I click edit credential again, the credential reverted to Anonymous. If I click refresh now, the refresh will be failed.
I find that there is already a same issue reported. Power BI team are working on it. Based on the information I get, the fix maybe available later this week (11/26). Please try it later and post back if issue still persists.
Best Regards,
Herbert
