Skip to main content
AEC Integrations

Integration

AEC Integrations maintained

How Azure SQL Database and Power BI exchange data

Azure SQL Database Microsoft Power BI Microsoft

We haven’t listed the types of data yet

The direction is shown below. The types of data aren’t listed yet.

Power Query Azure SQL database connector

→Sends to Power BI

Microsoft ships a first-party Power Query connector for Azure SQL database, at General Availability, supported in Power BI semantic models and dataflows, Fabric Dataflow Gen2, Power Apps dataflows, Excel, Analysis Services and Dynamics 365 Customer Insights. It supports both Import and DirectQuery, authenticates with Windows, Database, Microsoft Account, Basic or a service principal, and exposes the database through the Sql.Database and Sql.Databases functions. Power BI reads from the database; nothing is written back.

At a glance

How you get it
NativeOffered by Microsoft

Directory updates

Know when new tools and reviews land

AEC Integrations is live and still growing. Add your email for occasional updates as we expand the directory with new tools, integrations, and reviews.