Power Update – From Power BI Desktop to SQL Server

Industrial Strength Data Transfer from Power BI Desktop to SQL Server

Power ON is adding support to transfer the data from a Power BI Desktop data model to any version of SQL Server, including Azure, in Power Update.

To learn more about Power Update you can read in Power Pivot Pro’s blog.

In order to use the 30 day trial version, you can register and download Power Update.

How to setup a Power BI to SQL job?

Easy as 1-2-3

1. Create the data model with Power Query in Power BI

2. Open PUSQL.EXE and set the SQL Connection information, and select the PBID tables that should be transferred to the SQL Server.

3. Create a Power Update job, to schedule the transfer to run every minute, every hour or once a week

Advanced Features

DAX Query: In order to limit the data that is transferred from Power BI to SQL, Power Update can select part of the source data set. i.e.:

EVALUATE
FILTER ( Sales, AND (Sales[Version ID] = “Budget”, Sales[Year] = 2017))

What is Exported:

All M Columns, Calculated Columns, and Measures Created in Power BI Desktop.

Power Update Wizard