Publish Power BI Report with Power Bi Gateway

Publish/Share Power BI Report

Once the report is created (manually or using provided Y Soft template),administrators can share the report and give users access to view it.

images/s/-t6brkm/8803/3fowtp/_/images/icons/emoticons/information.svg Both viewing and publishing the reports requires "Power BI Pro" account.

images/download/attachments/160480515/image2018-11-16_8-49-39.png


images/download/attachments/160480515/image2018-11-16_8-50-45.png


Reference:


Power Bi Gateway

To keep the published report up to date, it needs to be refreshed periodically. There are two options to achieve this:

  1. Manually: refresh the data in Power BI Desktop and publish a new version.

    images/download/attachments/160480515/image2018-11-16_8-53-0.png



  2. Automatically: implement Power BI Gateway.


Implement Power BI Gateway

The Power BI Gateway requires exactly the same ODBC connection configuration as Power BI Desktop is using. Follow respective guides to configure this on the server where deploying the gateway:

  • To install the Power BI Gateway follow Microsoft documentation: https://docs.microsoft.com/en-us/power-bi/service-gateway-install

  • Once installed, go to Power BI account and add a data source. Follow Microsoft documentation: https://docs.microsoft.com/en-us/power-bi/service-gateway-manage

    • The ODBC data have to match in both Power BI data source and Power BI Desktop data source:

      images/download/attachments/160480515/image2018-11-16_9-4-53.png


      images/download/attachments/160480515/image2018-11-16_9-5-49.png



  • Confirm correct configuration under your PowerBI account:

    • Navigate to Settings:

      images/download/thumbnails/160480515/image2018-11-16_9-7-48.png
    • Navigate to "Datasets", expand "Gateway connection" section:

      • Select the Gateway and apply it to the report.

      • Confirm that status is green "Running on ..."

        images/download/attachments/160480515/image2018-11-16_9-14-17.png
      • Again in menu "Datasets", expand "Scheduled refresh" section and enable it:

        images/download/attachments/160480515/image2018-11-16_9-18-31.png


Reference: