Trace Id is missing

Maximize the everyday with Microsoft 365

Get online protection, secure cloud storage, and innovative apps designed to fit your needs—all in one plan.
For 1 personFor up to 6 people
A young woman works on a Surface laptop while Microsoft 365 App icons whirl around her head.

On-premises data gateway (personal mode)

The Microsoft On-premises data gateway (personal mode) enables Power BI users to connect to on-premises data sources such as SQL Server.

Important! Selecting a language below will dynamically change the complete page content to that language.

Download

  • Version:

    3000.230.12

    Date Published:

    7/15/2024

    File Name:

    On-premises data gateway (personal mode).exe

    File Size:

    400.0 MB

    The On-premises data gateway (personal mode) is a client agent to refresh data from on-premises data sources such as SQL Server, Oracle, Teradata, Files, etc. It empowers business analysts to securely and easily keep their data in Power BI in sync with their on-premises data. Analysts can now refresh content in Power BI without having to depend on the IT department to configure any gateway or data sources. Once the On-premises data gateway (personal mode) is running on the computer, data refresh is seamless. When you run setup, the On-premises data gateway (personal mode) Wizard guides you through configuring your connection from Power BI service to various on-premises data sources.

  • Supported Operating Systems

    Windows 10, Windows Server 2019, Windows Server 2022, Windows 11

    .Net Framework 4.8 or greater

  • Run the downloaded executable to install and configure the on-premises data gateway (personal mode).

Follow Microsoft

Back To Top