Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsHard
A data analyst is deploying a new Power BI report that connects to an on-premises Oracle database. The report needs to be refreshed daily at 6 AM. After publishing the report to the Power BI service, the analyst attempts to configure the scheduled refresh but receives an error indicating that the data source credentials cannot be validated. The gateway is online and correctly installed. What is the most likely cause of this error?
- AThe Power BI report was published to 'My Workspace' instead of a shared workspace.
- BRow-level security (RLS) is enabled on the dataset but not properly configured.
- CThe Oracle data source has not been added and configured within the Power BI Gateway.
- DThe user attempting to configure the refresh is not an administrator of the workspace.
Show answer & explanationAnswer & explanation
Correct answer: C. The Oracle data source has not been added and configured within the Power BI Gateway.
Even if the gateway itself is online, each specific data source (like the Oracle database) needs to be explicitly added and configured within the gateway settings, including its credentials. If this step is missed or the credentials are incorrect, the Power BI service cannot validate the connection for refresh.
Why the other options are wrong
- A. The type of workspace does not affect the validation of data source credentials for an on-premises gateway connection.
- B. RLS issues typically relate to data visibility, not the ability to validate data source credentials for refresh.
- D. Workspace admin role is needed for gateway configuration, but the error specifically mentions 'data source credentials cannot be validated', implying the gateway *knows* about the data source but not its login.
Power BI Gateway Data Source Configuration
For each on-premises data source (e.g., SQL Server, Oracle) that Power BI service needs to access via a gateway, a corresponding data source connection must be configured within the gateway, including its specific credentials.
- Gateway acts as a bridge, but individual data sources need configuration.
- Credentials for each data source are stored securely within the gateway.
- Essential for scheduled refreshes of on-premises data.
Memory trick: Gateway Needs Data Source Details.