Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Drag & Drop Scenario
Read the scenario requirements and decide your answer. Click Check Answer below to see the marked solution.
Hotspot Solution:
Configure an on-premises data gateway Install and set up the on-premises data gateway to enable secure data transfer between the on-premises SQL Server and Power BI service. Add a data source Add the SQL Server database as a data source within the configured gateway, providing necessary connection details (e.g., server name, database name, and credentials). Add the dataset owner to the data source Ensure the dataset owner has access to the data source in the gateway, granting them permission to use the connection for refreshing the dataset. Configure a scheduled refresh Set up the dataset in Power BI to refresh on a daily schedule, using the gateway to pull updated data from the SQL Server. Note : adding a data source, adding the dataset owner to the data source, and configuring a scheduled refresh—are performed within Power BI Service
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
configure an on premises data gateway, add a data source, add the dataset owner to the data source, configure a schedule refresh
* Answer: The correct sequence of actions to enable Power BI service to refresh a dataset from an on-premises SQL Server daily is: 1. Configure an on-premises data gateway This establishes a secure connection between Power BI service and your on-premises SQL Server. 2. Add a data source Define the SQL Server database as a data source in the gateway configuration. 3. Add the dataset owner to the data source Ensure the dataset owner has access permissions to use the gateway and data source. 4. Configure a scheduled refresh Set up the refresh schedule (daily in this case) in the Power BI service. This sequence ensures connectivity, permissions, and automation for daily refresh.
The answer is correct. note: it is better first adding the owner and then scheduling the refresh to avoid you being the default dataset owner.