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

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

    • 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