Skip to main content
AEC Integrations

Integration

AEC Integrations maintained

How Microsoft SQL Server and Power BI exchange data

Microsoft SQL Server 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 SQL Server connector

→Sends to Power BI

Microsoft ships a first-party Power Query SQL Server connector, 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 Import and DirectQuery, authenticates with Database, Windows, organizational-account or service-principal credentials, and exposes the instance 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.