cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jasonlosser Regular Visitor
Regular Visitor

Save PowerBI Desktop DataModel results to SQL Server?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Save PowerBI Desktop DataModel results to SQL Server?

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

1 REPLY 1
Super User
Super User

Re: Save PowerBI Desktop DataModel results to SQL Server?

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 270 members 2,184 guests
Please welcome our newest community members: