Replace 2021 March:
Now you can export the information immediately from Energy BI Desktop utilizing my software, Energy BI Exporter. Learn extra right here.
Replace 2019 April:
When you’re thinking about exporting the information mannequin from Energy BI Service to SQL Server test this out.
Some time in the past I wrote a weblog put up explaining learn how to Export Energy BI Information to SQL Server with R. In that put up I defined learn how to get the job performed in Energy BI Desktop utilizing R scripts. On this put up I clarify learn how to export Energy BI Service knowledge to SQL server. YES! You may export knowledge from Energy BI service to a SQL Server database sitting in your on-premises surroundings. Maintain studying to see how.
That is going to be a brief put up as I already lined the primary a part of the method in my different put up on Export Energy BI Information to SQL Server with R. So on this put up I present you learn how to use the Energy BI Desktop file you already created utilizing the tactic defined in that weblog put up to export your Energy BI Service knowledge to an on-premises occasion of SQL Server. All you have to do is to
- Publish the prevailing Energy BI Desktop answer to Energy BI Service
- Set up On-premises Information Gateway in PERSONAL MODE
Be aware: R is NOT supported by the present model (Model Quantity: 14.16.6614.5) of the On-premises Information 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 for those who don’t set up the On-premises Information Gateway in Private Mode.
To see the dataset settings:
- Login to Energy BI Service
- Click on the gear icon (
)on prime proper of the web page - Click on “Settings”
- Click on “Datasets” tab then click on on the specified dataset
- Broaden “Gateway connection”
You may obtain On-premises Information Gateway from right here. The set up is tremendous simple you simply have to bear in mind to
- Choose “Private Mode” while you’re putting in the gateway.
- Now return to the “Dataset settings” and increase “Gateway connection”. The Gateway must be on-line on Private Mode.
- Tick the “Use your knowledge gateway (private mode)
- Broaden “Information supply credentials” and click on “Edit Credentials” for all knowledge 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 under. Click on OK
- Now question the underlying desk(s) in SQL Server database to see if the information has been imported efficiently
- Broaden “Schedule refresh” and alter the configuration as desired the clicking “Apply”
All performed!
