Power BI

How to Trace a Grayed-Out Power BI Refresh Credential Setting to Its Data Source

Trace a grayed-out Power BI refresh credential setting in 5 steps to its gateway or cloud source and find out who can change it.

If the Data source credentials controls are grayed out in Power BI, first identify how the semantic model reaches that source. With an on-premises data gateway, credentials are typically managed in the gateway’s data source definition by a gateway administrator, so the disabled controls can be expected. This five-step guide helps semantic model owners and Power BI admins trace the setting to its connector, gateway mapping, and credential owner. You’ll need access to the workspace and, for gateway-managed sources, help from a gateway admin. Microsoft’s current guidance covers Power BI service semantic model settings; labels and pane layout may vary as the settings pane preview evolves.

Prerequisites

  • Access: Power BI service access to the workspace and semantic model. Gateway configuration access is helpful, but only a gateway admin can add or manage gateway data sources.
  • Tools: A browser, the published semantic model, and optionally the PBIX file in Power BI Desktop or Power Query Editor.
  • Time: About 10–20 minutes if you have the needed permissions; longer if you need an administrator to identify the mapping.
  • Difficulty: Intermediate.

Steps

Step 1: Open the semantic model’s refresh settings

In the Power BI service, open the workspace that contains the report’s semantic model. Open the model’s settings (the model may appear as a dataset in older interface labels). Find Gateway and cloud connections and Data source credentials. Record which section is disabled and any gateway name or status shown. If the report uses a live connection or DirectQuery, confirm its connection type before assuming an import refresh credential should be editable; DirectQuery queries the source rather than importing data during a scheduled data refresh.

Step 2: List the source connectors used by the model

Open the PBIX in Power BI Desktop if you have it, then choose Transform data to inspect Power Query queries. In Power Query Editor, use Data source settings to review sources for the current file. Note each connector and its endpoint details, such as server and database, file path, or site address. You can also inspect each query’s Source step. Do not paste passwords or tokens into notes or send them to an administrator; connector type and endpoint are usually enough to locate a matching definition.

For example, a query that connects to SQL Server DB-SALES-01 and database SalesDW should be compared with a gateway definition for that server and database. A similar display name alone is not proof that it is the same source.

Step 3: Check whether the source is routed through a gateway

Return to the semantic model’s Gateway and cloud connections section. Determine whether an on-premises gateway or virtual network data gateway is selected, and check whether its status is online. Power BI requires a gateway for sources it cannot reach over a direct network connection. For an enterprise gateway, the model can use only a gateway that has matching definitions for all required on-premises sources and that you are allowed to use. A personal gateway follows a different pattern: its credentials are managed through the semantic model’s credential settings.

If the selected enterprise gateway is online and the source is mapped, a grayed-out credential section may be expected: the gateway data source definition holds the credentials. Microsoft specifically distinguishes this behavior from personal gateway refresh, where credentials must be supplied in the model settings. Microsoft’s scheduled refresh guidance documents the distinction.

Step 4: Match the connector to the gateway data source definition

Ask a gateway admin to compare your connector and endpoint with the gateway’s configured data source definition. For SQL Server, compare the server and database values; for other connectors, compare the relevant endpoint and connection properties. Names can be similar while pointing to different definitions, and administrators may have multiple definitions for the same underlying source with different credentials. Also verify that your account is listed among the users permitted to use the definition. Only gateway admins can add data sources to an enterprise gateway.

If your model combines cloud and on-premises data in one Power Query mashup, ask the admin whether the cloud source is also routed through the gateway. Power BI documents that a query merging or appending gateway-connected and cloud sources can use the gateway connection for the cloud source too. Microsoft’s data refresh documentation explains this routing and gateway mapping.

Step 5: Confirm the credential owner and choose the right fix

Once the endpoint and mapping match, ask the owner of that connection to confirm which authentication method and account the definition uses. If it is an enterprise gateway source, the gateway admin must update its credentials or grant your account access; changing the semantic model’s disabled credential field is not the fix. If the source is cloud-only and directly reachable, or uses a personal gateway, check whether you are the semantic model owner and whether credentials are available in the model settings. If you are not the owner, Power BI may require the owner to take over the model before changing credentials.

After the responsible person makes an authorized update, run an on-demand refresh and inspect Refresh history for the result and any error message. Do not change gateway mappings or replace stored credentials until the source endpoint and intended account have been confirmed.

Troubleshooting

  • The gateway is missing from settings: Ask the administrator to verify that every on-premises source in the model has a matching definition and that your account is on its Users list. Server or database mismatches can prevent a gateway from appearing.
  • The gateway is offline: Check the gateway status in model settings and contact its administrator to restore service. Re-entering credentials in a disabled model setting will not bring an offline gateway online.
  • Credentials appear invalid, but refresh succeeds: Some gateway connection tests omit optional connector parameters, which can produce a test error even when refresh works. Compare the message with Refresh history and actual refresh outcomes before changing credentials; see Microsoft’s gateway troubleshooting guidance.

FAQ

Why are Power BI data source credentials grayed out?

A common reason is that an enterprise on-premises gateway manages the source credentials. The setting can also be unavailable when your account does not own the semantic model or lacks the needed permissions. Check the gateway connection and model ownership before treating it as an error.

Can I change gateway credentials from the semantic model settings?

For an enterprise gateway definition, ask a gateway administrator to manage the credentials in the gateway configuration. Personal gateway credentials are managed differently and are supplied in the semantic model settings.

Does every cloud source need a gateway?

No. A cloud source that Power BI can reach directly generally does not need a gateway. However, a query that combines a gateway-connected source with a cloud source can route both through the gateway, depending on the query and gateway configuration.

More in Power BI