Manage files and semantic models in Power BI

Setup the gateway (personal mode)

  1. In the Power BI service, reload (F5) the semantic model 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 using your organizational account.

  7. Once setup, return to and reload the semantic model 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 semantic model

  1. Before refreshing the semantic model, 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:\Allfiles\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 semantic model.

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