Data source credentials greyed out after taking over the dataset

[Anonymous]

I have published a dashboard to the power bi service platform. My colleague wants to refresh the dataset, but even after having admin rights and "taking over" the dataset, he is unable to edit the data source credentials, as the option gets greyed out. 

I have the personal gateway installed on my system and my datasets include:

1. SharePoint list

2. Sql server (import mode)

3. API links

[MateusHSD]

I don't know why this should be done, in other datasets the refresh was working normally, but in this dataset it wasn't. Creating the gateways worked for me.

[john-v1]

Mine was greyed out too, and funny enough what fixed it was letting another admin in the workspace take over control of the dataset, and then I took back control.

It is important to note that when he took over control the first time, a lot of stuff was greyed out for him (including Gateway and Cloud Connections, Parameters, and few others).

Only when I took back control from him, did everything start to work for me.

[jaweher899]

If your colleague is unable to edit the data source credentials for the dataset in the Power BI service, even after taking ownership of the dataset and having admin rights, it is possible that the data source is configured to use a gateway and the gateway settings are preventing your colleague from making changes.

To resolve this issue, you can try the following steps:

1. Check the gateway settings: In the Power BI service, go to the "Manage gateways" page and check the settings for the gateway that is being used for the dataset. Make sure that your colleague has been added as an administrator for the gateway and that the data source credentials are configured correctly.

2. Check the dataset settings: In the Power BI service, go to the "Datasets" page and click on the dataset that is causing the issue. Click on the "Settings" icon and then click on "Security" to check if your colleague has been added as a member of the dataset. Also, check if the "Prevent others from changing the data source credentials" option is enabled, and if so, disable it.

3. Check the data source permissions: Make sure that your colleague has the necessary permissions to access the data source. For example, if the data source is a SQL Server database, make sure that your colleague has been granted the appropriate permissions to access the database and modify the credentials.

4. Try refreshing the data in Power BI Desktop: If your colleague is still unable to edit the data source credentials in the Power BI service, you can try opening the dataset in Power BI Desktop and refreshing the data there. After refreshing the data, save the changes and publish the updated dataset to the Power BI service. This may help to resolve any issues with the data source credentials.