Strategy ONE

Publish to Power BI Cloud Using an On-Premise Gateway

After you build your report, you can publish it to the cloud.

Prerequisites

Publish to Power BI Cloud

  1. Download the gateway in Standard mode. For more information and the download file, see Connect to on-premises data sources with a Power BI gateway.

  2. Open the gateway installer.

  3. Type your email address and click Sign in.

  4. Select Register a new gateway on this computer and click Next.

  5. In New on-premises data gateway name, type a name.

  6. Type a Recovery key.

  7. Re-enter the recovery key and click Configure.

  8. After the gateway displays a successful confirmation, click Close.

  9. Go to Power BI Cloud and sign in using your corporate credentials.

  10. Ensure you can access the gateway in Power BI:

    1. Click Settings in the top navigation.

    2. Click Manage connections and gateways.

    3. Click the On-premises data gateways tab and click Check Status.

    4. Ensure Online displays.

  11. In Power BI Desktop, open data source and add columns and other items.

  12. Click Publish.

  13. If needed, type a name for your file and click Save.

  14. Choose a workspace and click Select.

  15. Go to the Power BI Cloud workspace and choose the model.

  16. Expand File and click Settings.

  17. Expand the Gateway and cloud connections tab.

  18. Select your data source and click Add to gateway.

  19. Type a Connection name.

  20. Enter the corporate credentials you use for Power BI Cloud and the gateway.

  21. Ensure the Server field value is the same server used in Power BI Desktop. This value must match exactly, including case sensitivity.

  22. Click Create.

  23. Expand the Maps to drop-down list and choose the connection you just created.

  24. Click Apply.

  25. Open your new data source.

  26. Click Explore this data and choose columns to view insights.