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

Rock Version: v20.0
Last Modified: 2026-09-04 2:15 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.

Considerations for Embedded Reports

Rock includes the awesome ability to embed Power BI reports right onto a page, which provides a great user experience without end users having to learn or use a special reporting client. However, this power comes at a cost. We have compiled the various options for utilizing Power BI reports in Rock and what Microsoft charges for these features below.