Exam PL-300 topic 1 question 17 discussion

Current sequence looks good

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

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

What if I add the Data Source before setting up the Data Gateway?

The answers seems OK to me: 1 - Configure an om-prem gateway 2 - Add a data source 3 - Add the dataset owner to the data source 4 - Configure a scheduled refresh

correct sequence

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,

This was on the exam on 22/2/2024 (:

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?

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.

SETUP ON PREMISES DATA GATEWAY ADD DATA SOURCE ADD DATASET OWNER SCHEDULE REFRESH

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

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?

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.

Could anyone provide a link to this? Seem like this requires pragmatic experience

Any good link for this topic?

Why Add a data source must be before Add dataset owner to data source?