Save PowerBI Desktop DataModel results to SQL Server?

[jasonlosser]

I enjoy using PowerBI Desktop's JSON parsing and webscraping abilities.  I frequently use them to get web data for a view of new info from the web.   However, I would like to deploy the model to my Premium workspace and have the results from the workspace periodically save to a local SQL server.

I do not want to have to do so manually.

Anyone else try this?

[GilbertQ · Accepted solution]

Hi there

Currently Power BI is a read-only tool, so it does have the capability to export the data to SQL Server.

What you could look at doing is to possibly use Azure Data Factory with the Power Query plug-in to extract the data and save it to a SQL Server?