Forum Discussion

dyee4613's avatar
dyee4613
Helper I
6 years ago

Adding Sharepoint to a Gateway

Hi.  I just updated my gateway so we could add a sharepoint site.  The credentials are correct.  It's the same one I used to access the data in Power BI Desktop and the user is an owner for the sharepoint site.  Why is it saying it is invalid?  I tried multiple user names. 

 

oothillGateway:Invalid connection credentials.
Underlying error code:-2147467259
Underlying error message:

The credentials provided for the SharePoint source are invalid. (Source at

 

 

Note: I was able to give myself access via the Data Source Credentials for the specific file using OAUTH2 --> Organizational

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    Did the user put in their details for the authentication when you created the data source?
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi dyee4613 ,

    Have you used the same credentials that you configure in pbix report file on the service side?  AFAIK, current power bi only allows you to use the same datasource and credentials as publish pbix file for refresh operations.

    Regards,

    Xiaoxin Sheng