Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data Source Credential Error when scheduling refresh

Hi

 

I am having a similar issue when updating a report/dataset. 

The dataset is from from excel sheet  in Sharepoint.

I have published this report in power BI service

Everytime I am trying to update the report I receive the following error message 

 

 
Activity ID:c204d515-06ae-445d-b677-b1f3bc6d9dd1
Request ID:c78ef477-83ce-f6ec-2d02-f0d5404ab600
Status code:400
Time:Fri May 15 2020 13:23:46 GMT-0700 (Pacific Daylight Time)
Service version:13.0.13172.204
Client version:2004.4.00903-train
Cluster URI:https://wabi-north-europe-redirect.analysis.windows.net/

 

Failed to update data source credentials: The credentials provided for the Web source are invalid. 

 

I am using "Basic" for authentication method. and the privacy setting is set to organization. 

 

Any help would be appreciated. 

 

Thanks

M

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I got  this to work properly now. I had to use the web resource for "OAuth2" to appear.

     

    Thanks

    Manny

15 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    I've never seen Basic authentication be successful against SharePoint, it is generally OAuth if SharePoint Online or possibly Windows if on-premises.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Greg.

      Actually i don't see an option for OAuth. The only ooptions for authentication method I see are : Anonymous, Windows and Basic. 

      Am I looking at something wrong? 


      Thanks

      Manny

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago

        Which connector are you using?

         

        What version of SharePoint are you using:

        • SharePoint Online
        • SharePoint 2019
        • SharePoint 2016
        • SharePoint 2013
        • SharePoint 2010
        • SharePoint 2007

        ?

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    Anonymous 

    There was a known issue is going on with sharepoint, Please check once.

    https://powerbi.microsoft.com/en-us/support/

     

    If it is not related to this, Please try to authenticate with the "OAuth2" and try to re-pro the issue.

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    In case it does not help, please provide additional information and mark me with @

     

    BR

    venal.

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Anonymous 

     

    For refresh to work properly when connecting to a SharePoint Online data source using AAD OAuth, you have to use the same account that you use to sign in to the Power BI service.

     

    For further information, you may refer the following document.

    Refresh a dataset stored on OneDrive or SharePoint Online 

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi All,

    I am facing similar issue while deploying cube as dataset from vs to pbi site. I'm using windows authenctication and my datasource is sqlserver 2017. I have like 10 datasets to be deployed out of which 8 are success, but remaining 2 seem to throw "Refresh can't be scheduled because the data set doesn't contain any data model connections, or is a worksheet or linked table. To schedule refresh, the data must be loaded into the data model."   I have tried updating permission settings, updating processing type of the datasets but still no luck. If I deploy 4 datasets on one day, I can't deploy the rest of them on the same day. However, If i try the following day, it works. I have tried restarting my servers but that too doesn't do the trick. My datasets deployments that point to QA servers seem to work, but ones on staging servers give me above mentioned error. I have compared permissions and settings of QA and Staging and they are exactly the same. 

    Any help would be appreciated!!

    Thank you

    @refresh

  • alpeshpatel's avatar
    alpeshpatel
    New Member
    3 years ago

    Similar issue , need help

     

    I have created a report using excel doc as web source from team site which works fine. When I published the report and try to refresh dataset from workspace I get Error "Processing errorThe credentials provided for the Web source are invalid. (Source at" . So I tried providing data source credential for dataset using OAuth2 authentication with Oragnizational privacy level , gives me similar error "Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at".