Forum Discussion
Credential type error
I am connecting to a single sharepoint file via a web content connector. I have been using my organizational account credentials but this stop working. There hasn't been any changes in the file access rights.
Anyone has a clue why and how to fix this? It does not seem that the other authentication methods work either for this file.
The problematic part is : "SharePoint URL redirections (:x:/r/)"
- Open the SharePoint site in your browser (not the file).
- Click Settings → Site information
- You’ll see Site address, for example: https://contoso.sharepoint.com/sites/Finance
This is the exact URL you should use in Power BI.
2 Replies
The problematic part is : "SharePoint URL redirections (:x:/r/)"
- Open the SharePoint site in your browser (not the file).
- Click Settings → Site information
- You’ll see Site address, for example: https://contoso.sharepoint.com/sites/Finance
This is the exact URL you should use in Power BI.
Web connector can work only with the SharePoint site URL, not with redirected file URLs(:x:/r/). It may have worked earlier because a valid site URL was used or credentials were cached. Using the site-level SharePoint URL in Web connector should resolve the error. otherwise, the SharePoint / SharePoint Folder connector is the safer option.
