Solved: Save PowerBI Desktop DataModel results to SQL Serv...

jasonlosser · ‎09-17-2019

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 · ‎09-17-2019

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?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

GilbertQ · ‎09-17-2019

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?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

Save PowerBI Desktop DataModel results to SQL Server?

Re: Save PowerBI Desktop DataModel results to SQL Server?

Re: Save PowerBI Desktop DataModel results to SQL Server?

Helpful resources

Challenge: Can You Solve These?

Incoming: New and Improved Badges

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Analytics in Azure virtual event