Core Docs - Church Management - Use the On-Premises Data Gateway

Rock Version: v20.0
Last Modified: 2026-09-28 12:25 PM

As you use Power BI in the cloud you’ll want to ensure that your data is always up to date. While you can do that manually using the Power BI Desktop application, you can automate the process using the Power BI On-Premises gateway. This is a free tool that will keep your data in Rock in sync with the Power BI cloud. Below are steps for getting this tool configured. If you prefer a video tutorial, this YouTube video from Microsoft covers the steps in detail: https://www.youtube.com/watch?v=GwuRQhm241c.

Power BI options and costs

Rock can embed Power BI reports right on a page with the Power Bi Report Viewer block, so staff can see them without learning a separate reporting tool. Power BI is sold by Microsoft, not Rock, and its prices change over time. The following table compares your options, from free to the most expensive ($$$). Check Microsoft's current pricing before you choose one.