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

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

?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I am using Web version of sharepoint....so Sharepoint Online.

     

    I am not sure what connector are you referring to....I am not using any connector as far as i know.


    My apologies for these questions. Its the first time I am trying to deal with the refreshing. 

     

    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