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
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

andreucci

 

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

  • andreucci's avatar
    andreucci
    Frequent Visitor
    9 years ago

    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

     

     

    • 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