DRAG DROP
-
You publish a dataset that contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Current sequence looks good
the video below confirms the answer https://www.youtube.com/watch?v=WpfGIC3i2D8&list=PLApPcvU5-R24K3mbxORV7T3ckVLfDjmHF&index=40
Given Answer is correct Set up an on-premises data gateway: Download and install an on-premises data gateway on a machine that has access to the SQL Server database. Make sure that the gateway is registered to the same workspace as the dataset. Configure a data source: In the Power BI service, go to the dataset settings, and select the data source. Then, enter the necessary details, including the server name, database name, and credentials. Schedule refresh: In the dataset settings, go to the "Scheduled refresh" tab, and set up a refresh schedule. Ensure that the gateway is selected as the "Data source credentials" option. Publish the dataset: Finally, publish the dataset to the Power BI service. The dataset will be refreshed according to the schedule you set up, and the on-premises data gateway will allow the service to connect to the SQL Server database. No confusion, and no need to discuss further
3rd step should be add dataset owner to the data source
then the 4th step should be schedule the refresh
Publish the dataset isn't one of the answers tho
Answer correct Passed my exam (22/09/2023) - with this question
This question was in Exam today.
SETUP ON PREMISES DATA GATEWAY ADD DATA SOURCE ADD DATASET OWNER SCHEDULE REFRESH
Could anyone provide a link to this? Seem like this requires pragmatic experience
https://learn.microsoft.com/en-us/training/modules/manage-datasets-power-bi/4-power-bi-gateway and the study page after that https://learn.microsoft.com/en-us/training/modules/manage-datasets-power-bi/5-dataset-refresh It does not necessarily talk about this order, but it does help to understand how this works. With those pages I was able to logically put the four things in the correct order.
One thing I didn't understand is that first we need to add data source and then configure an on-premises data gateway. Someone please help me understand why we are not following this order?
FIRST DONWLOAD THE DATEGATEWAY FROM POWER BI .COM
Here are the correct Sequences: First Step : Add a data source. This involves specifying the connection details, such as the server's name, database name, and authentication credentials. Second Step: Configure an on-premises data gateway. The gateway acts as a bridge between our on-premises data sources and the Power BI service in the cloud. It allows secure data transfer and access. Third Step: Add the dataset owner to the data source. Ensure that the dataset owner (the Power BI user or service account) has appropriate permissions to access the on-premises SQL server database. This is important for successful data retrieval during refresh. Fourth Step: Configure a scheduled refresh. Schedule the refresh to occur daily to keep the dataset up to date.
Nope, the first step should be Configure data gateway. then, in second step we could have ability to add data source. https://www.youtube.com/watch?v=iq9M_ncz0tw --> please refer to this link as example. I just wonder the step 3 and 4, why do we need to add dataset owner before setting a schedule refresh.
That was on video...
This was on the exam on 22/2/2024 (:
This question is dumb AF, like it doesnt really matter if you create dataset or gateway first, all you need to remember is to have it ready before running refresh,
1. Configure una puerta de enlace de datos local. 2. Agregue un origen de datos. 3. Agregue el propietario del conjunto de datos al origen de datos. 4. Configure una actualización programada.
given exam on 21th Oct 2023 , This Question is in the exam . I scored 79 , No need to take ful version most of the question covern under 24 pages only.
I don't understand what "add dataset owner to the data source" does. If the "data source" is the on-prem SQL DB and "you" are or are going to be the owner of the dataset, shouldn't you be added to the SQL DB first to be able to set it up in the gateway?
Any good link for this topic?
Seems the answer is correct- https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
comparing to the given answer, i would select add data owner as the last one - https://learn.microsoft.com/en-us/training/modules/manage-datasets-power-bi/5-dataset-refresh
You cannot schedule a refresh if the data owner is not established.
correct sequence