Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
7 years ago

Export data in model, or query results, to SQL table or Azure SQL or similar?

I am using Power Query to extract data from some various sources and using some custom connectors.

 

Is there anyway I can take the results of those queries and push them into Azure SQL or on prem SQL or a similar table format?  I need to store them for long term storage and to my knowledge there is no way to store data long term in Power BI.  *Saving data so I can archive it for a few years.