Unable to access "Data source credentials" section in Power BI Service dataset settings

[meggio84]

Hello Power BI Community,

I'm experiencing an issue with my Power BI dataset where I cannot access the "Data Source Credentials" section to configure credentials for my MySQL database hosted on AWS RDS.

Problem Description:
I have a dataset in Power BI Service that connects to a MySQL database on AWS RDS
When trying to refresh the dataset, I get this error: "Scheduled refresh is disabled because credentials are missing for at least one data source"
When I go to dataset settings > Data Source Credentials section, it's grayed out and inaccessible
In the "Gateway and cloud connections" section, I can see my MySQL connection (FinRisk), but the "Apply" button is disabled/grayed out
What I've Already Tried:
Removed the gateway association (it was showing an error)
Configured the connection as a cloud connection mapping to "FinRisk"
Tried to access the credentials section through different browsers
Ensured my AWS RDS MySQL instance is publicly accessible with the proper security group rules
Verified that the MySQL connection works from other tools
Error Details:
When attempting to refresh the dataset manually, I get this error:

"Error: Scheduled refresh is disabled because credentials are missing for at least one data source. To restart the refresh, go to the settings page for this dataset and enter credentials for all data sources, then re-enable scheduled refresh.
Cluster URI: WABI-ITALY-NORTH-A-PRIMARY-redirect.analysis.windows.net
Activity ID: a4610e36-c202-4ea3-a006-926b60257ace
Request ID: f2ceba8e-dcd1-3ce8-31d1-b8621acea15f
Time: 2025-05-20 13:48:54Z"

Thanks to everyone who will provide me with any help

Enrico

[ibarrau · Accepted solution]

Hi. As far as I remember you can't connect directly. You need a standard or enterprise data gateway. I guess it's still like that, it's been a while since I have worked with that.

I'm not sure if it's the exact same thing as postgres and that's the issue, but maybe you can check this article out. It could help.

https://blog.ladataweb.com.ar/post/187904496250/conectar-power-bi-a-rds-postgres-en-aws

I hope that helps,

[v-dineshya · Accepted solution]

Hi @meggio84 ,

Thank you for reaching out to the Microsoft Community Forum.

Please check below Steps to Fix the issue.

Step 1: Check Dataset Source Mode (Gateway vs Cloud)

Power BI uses cloud credentials for MySQL if you're using Import or DirectQuery, and the source is publicly accessible. Make sure your dataset is not requiring a gateway.

Go to Power BI Service, Ensure FinRisk is listed under "Data sources" only under Cloud connections, not a Gateway cluster
If you previously created it under a Gateway, remove that gateway data source.

Step 2: Clear Connection Mappings in Power BI Service

Sometimes stale or broken bindings between dataset and cloud connections prevent credential configuration.

Go to Power BI Service, Under Gateway and cloud connections, click “Remove” or “Clear” if there’s an inactive or broken mapping.

Delete and re-create the cloud connection to FinRisk:

Go to Manage Connections and Gateways from your name menu, Under Connections, find and delete FinRisk. Recreate it as a cloud connection, test it directly to your RDS

Step 3: Rebind the Dataset to the Cloud Connection

After recreating the cloud connection: Go back to the dataset > Settings > Gateway and cloud connections

You should now be able to select the newly created FinRisk cloud connection. If successful, “Apply” should be enabled. click it After applying, go to Data source credentials section it should now be editable.

Step 4: Re-publish with Clean Binding (If Still Broken)

If the above doesn’t work, the dataset metadata might be corrupted.

Open the original Power BI Desktop file (.pbix). Go to Transform Data > Data Source Settings. Ensure it's using “MySQL Database” with basic auth (not Windows/gateway). Re-publish the file to Power BI Service. Then re-check the dataset settings to bind to the new FinRisk cloud connection.

Please refer Microsoft article.

Gateways - Update Datasource - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @meggio84 ,

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @meggio84 ,

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @meggio84 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[ibarrau · Accepted solution]

Hi. As far as I remember you can't connect directly. You need a standard or enterprise data gateway. I guess it's still like that, it's been a while since I have worked with that.

I'm not sure if it's the exact same thing as postgres and that's the issue, but maybe you can check this article out. It could help.

https://blog.ladataweb.com.ar/post/187904496250/conectar-power-bi-a-rds-postgres-en-aws

I hope that helps,