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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg,

 

Thanks for the suggestion. I believe i have used sharepoint folder earlier. 

I will give it shot with Sharepoint Online and see how it goes. I will update you what I find out. 

 

Thanks again for the help.

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Greg,

     

    I looked into the Sharepoint Online....but it looks like I have to make a list first on sharepoint that i can talk to using power BI. 

    Is there any way I can use my spreadsheet saved under documents in sharepoint as a source? and link to that using power bi?

     

    Let me know if i am making any sense.

     

    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"