Load to Azure SQL database with dataflows
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
|Enabled for||Public preview||General availability|
|Users by admins, makers, or analysts||Nov 2022||-|
In addition to the standard Power BI data lake as a destination, you can use dataflows to store your data in Azure SQL.
With this new feature, you can load your data into any Azure SQL database by using dataflows. You can create new tables or load to existing tables with mapping. There are also options to control the update methods (for example, append or replace) for loading, so you have flexibility with how your data is loaded.
The default destination to load your data is the Power BI data lake, with Azure SQL as an additional destination.