Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsMedium
A Power BI developer needs to ensure that a newly deployed dataset, which uses an on-premises SQL Server database, can be automatically refreshed daily. The dataset has already been published to a workspace. What is the next logical step the developer must take in the Power BI service to enable the scheduled refresh?
- AConfigure the dataset's credentials for the data source.
- BSet up a subscription for the report.
- CInstall the Power BI Gateway on the SQL Server machine.
- DCreate a Power BI App for the report.
Show answer & explanationAnswer & explanation
Correct answer: A. Configure the dataset's credentials for the data source.
After the dataset is published and the gateway is installed (which is a prerequisite), the Power BI service needs to know the credentials to use when connecting to the on-premises SQL Server via the gateway. Configuring these credentials for the data source within the dataset settings is crucial for enabling scheduled refresh.
Why the other options are wrong
- B. Setting up a subscription is for receiving report snapshots, not for configuring the underlying dataset refresh mechanism.
- C. Installing the gateway is a prerequisite step, but the question implies the dataset is already published, and the gateway would typically be already installed and configured on the network.
- D. Creating a Power BI App is for content distribution, not directly related to enabling dataset refresh.
Power BI Dataset Data Source Credentials
Data source credentials in Power BI service provide the authentication details required for the Power BI service (via a gateway for on-premises sources) to connect to the underlying data source for data refresh.
- Required for data refresh
- Stored securely in Power BI service
- Used by gateway for on-premises sources
- Ensures proper authentication
Memory trick: Credentials are the key to unlock the data for scheduled refreshes.