Acterys-Power-BI-Sync-Architecture

Power BI offers unparalleled features to integrate and transform data. This output is often useful to add to an existing SQL data warehouse. in this post we explain how you can synchronize and load Power BI tables to SQL Server (Azure or on premise) and automate this process.

Acterys-Power-BI-Sync-Architecture
Acterys Power BI Sync Architecture

The tool to facilitate this process is Acterys Power BI Sync an easy to use Windows application that is available for download on the Acterys web site. The advantage of this approach is, that not only are the Power BI tables loaded to SQL Server but they are also enabled for planning and write-back with all of Acterys’ ground breaking planning features from top down data entry to driver based planning.

5 Easy Steps

  1. Install Acterys Power Sync:

    Acterys Power BI Sync and Update
    Acterys Power BI Sync and Update
  2. Configure your Power BI model (Power BI Desktop or Power BI Dataset / Dataflow):

    Power BI Sync Configuration
    Power BI Sync Configuration
  3. Choose model tables to load and optionally set refresh interval:
    Acterys Power BI Sync-Scheduled-Tasks
    Acterys Power BI Sync – Scheduled Tasks

    4. That’s it all data including calculated columns from the selected tables is now available in SQL Server

Available in: German French Spanish Italian Dutch