Forum Discussion
Anonymous
6 years agoNot applicable
Invalid credentials when adding web datasource (for connecting to sharepoint)
Hi, I´ve read a lot of answers about this but can´t figure it out yet. Desktop: I´ve connected to an excel file located in sharepoint using the web connector. I can´t add it to the gat...
- Anonymous6 years ago
Thanks for the great tips, much appreciated. I´ve actually realised you don´t need to add web sites to the on-premises gateway... #facepalm It sais it is "optional". It is logical of course, the web is outside the on-premises server. But, what about the credentials? I guess it uses the credentials given to pbi desktop because it is refreshing ok.
v-lionel-msft
6 years agoCommunity Support
Hi Anonymous ,
I suggest you use the SharePoint connector:
Create a report on a SharePoint List
Also, have you tried this authentication method?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.