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 u...
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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Sounds good, you will need to use "something" that supports OAuth or basically Office 365 authentication for SharePoint online.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

Thanks

Manny

  • pswain's avatar
    pswain
    Helper I
    5 years ago

    Hi, how di you get OAUTH option in Power BI scheduled settings, I only see the Basic and Anonymous, can you help me how can get Oauth option.

     

    I am also getting same error.

     

    The credentials provided for the Web source are invalid. (Source at https://zebra.sharepoint.com

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Having the same problem.  14 months later.   There must be a solution.  

    Where is OAuth in the connector settings in power bi service?  

    I'm reading I need that to solve my problem which is:   Successfully connecting power bi desktop to an excel sheet on OneDrive/SharePoint but, after publishing to the service, the service generates errors when attempting to connect.    I'm using the same credentials on desktop (which works) and pbi service (which doesn't)

    Anyone?

     

    "Scheduled refresh is disabled because at least one data source is missing credentials"