Invalid Credentials on Dataset Refresh - Sharepoint source

Question

I have a power BI model that connects to data sources stored on a sharepoint site, though only a single user (developer) is able to manually refresh the dataset. This is an issue because I need multiple users, who are admins of the sharepoint group, to be able to run their own refresh outside of the scheduled refreshes.&nbsp;The issue comes about because the credentials do not hold to OAuth2 authentication, but default back to Anonymous. Is this an issue that is a result of my own doing or an issue with the Power BI Service?

gilbertq · Answer

Hi thereCurrently have you tried creating it as a SharePoint list?Also in the Gateway there can only be one user per data source, and it cannot be configured per user.

anonymous · Answer

Hi,&nbsp;Changing to a sharepoint list data source does not fix the issue. I am not using a gateway as there is no need, none of the data is stored locally.This seems to me to be more of a Microsoft issue

Forum Discussion

Related content

Invalid credentials Snowflake

Invalid Connection Credentials

Key Vault Reference - Invalid Credentials

Invalid Credentials - Snowflake Connection

SharePoint Invalid/missing Credentials