Replace 2021 March:

Now you can export the information instantly from Energy BI Desktop utilizing my software, Energy BI Exporter. Learn extra right here.

Replace 2019 April:

When you’re curious about exporting the information mannequin from Energy BI Service to SQL Server examine this out.

Some time in the past I wrote a weblog put up explaining Export Energy BI Knowledge to SQL Server with R. In that put up I defined get the job completed in Energy BI Desktop utilizing R scripts. On this put up I clarify export Energy BI Service information to SQL server. YES! You may export information from Energy BI service to a SQL Server database sitting in your on-premises surroundings. Hold studying to see how.

That is going to be a brief put up as I already coated the primary a part of the method in my different put up on Export Energy BI Knowledge to SQL Server with R. So on this put up I present you use the Energy BI Desktop file you already created utilizing the tactic defined in that weblog put up to export your Energy BI Service information to an on-premises occasion of SQL Server. All you want to do is to

• Publish the prevailing Energy BI Desktop answer to Energy BI Service
• Set up On-premises Knowledge Gateway in PERSONAL MODE

Notice: R is NOT supported by the present model (Model Quantity: 14.16.6614.5) of the On-premises Knowledge Gateway in Enterprise Mode.

After you efficiently printed the mannequin to Energy BI Service you’ll discover that you simply can’t refresh the mannequin in case you don’t set up the On-premises Knowledge Gateway in Private Mode.

To see the dataset settings:

• Login to Energy BI Service
• Click on the gear icon ()on high proper of the web page
• Click on “Settings”

• Click on “Datasets” tab then click on on the specified dataset
• Increase “Gateway connection”

You may obtain On-premises Knowledge Gateway from right here. The set up is tremendous simple you simply have to remember to

• Choose “Private Mode” while you’re putting in the gateway.

• Now return to the “Dataset settings” and broaden “Gateway connection”. The Gateway ought to be on-line on Private Mode.
• Tick the “Use your information gateway (private mode)

• Increase “Knowledge supply credentials” and click on “Edit Credentials” for all information sources and go the credentials accordingly
• To check the answer simply navigate to your workspace and refresh the dataset
• At this level you’ll get a warning message as beneath. Click on OK

• Now question the underlying desk(s) in SQL Server database to see if the information has been imported efficiently
• Increase “Schedule refresh” and alter the configuration as desired the press “Apply”

All completed!