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 like you are using the wrong connector. When you "Get Data" in your Power BI Desktop, you are using a connector. And in your case, you should be choosing SharePoint Online List versus something list SharePoint List or SharePoint Folder I believe

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

      • 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
      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