Load to Azure SQL database with dataflows

Important

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 -

Business value

In addition to the standard Power BI data lake as a destination, you can use dataflows to store your data in Azure SQL.

Feature details

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.