Question
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.
Explanation
The Power BI service reaches an on-premises SQL Server only through an on-premises data gateway, so you install and configure the gateway first. Next you add the SQL Server database as a data source (connection) on that gateway, and then give the dataset owner access to that data source so the dataset can be bound to it. Finally you configure a daily scheduled refresh on the dataset. A virtual network data gateway is for Azure data services inside a virtual network, not for an on-premises server.
