Manage files and datasets in Power BI

Prepare for gateway data refresh

Note the following steps are not needed when using the data gateway in personal mode. You can proceed directly to the next objective (setup the gateway).

  1. In Power BI Desktop, open the Power Query Editor window, and select the ProductCost query.

  2. Edit the Source step, and then modify the file path to use the file share, as follows:

    \\DATA-AI\Data\ProductCost.xlsx

  3. Close and apply the Power Query Editor window.

  4. Save the Power BI Desktop file.

  5. Publish the Power BI Desktop file to the workspace, overwriting the dataset and report in the service.

Setup the gateway (personal mode)

  1. In the Power BI service for the instructor, reload (F5) the dataset settings page.

  2. Expand the Gateway Connection section and point out that no gateway is installed.

  3. Use the download dropdown list (located at the top-right), and select Data Gateway.

  4. In the new web page, download the personal mode gateway.

  5. Once downloaded, open the downloaded file.

  6. Complete the gateway setup by using the credentials of the instructor account.

  7. Once setup, return to and reload the dataset settings page.

  8. Assign the personal gateway, and the edit the credentials for the two data sources.

  9. For both data sources, set the authentication method to WindowsWithoutImpersonation, and set the privacy level to Organizational.

  10. Optionally, expand the Scheduled Refresh section, and show how to configure a recurring schedule.

Refresh the dataset

  1. Before refreshing the dataset, open the Sales Monitoring dashboard.

  2. Edit the details of the Sales, Profit Margin tile to display the last refresh time.

  3. Right-click the D:\PL300\Demo\Resources\UpdateDatabase-LoadAdditionalSales.ps1 file, and then run with PowerShell. This script will load December 2020 sales data into the database.

  4. In the Power BI service for the instructor, from the Navigation pane, refresh the Sales Analysis dataset.

  5. When the refresh completes, point out how the dashboard tile December 2020 column appears, and that the refresh time is NOW.