Connect to on-premises data sources with a Power BI gateway
Keep your dashboards and reports up to date by connecting to your on-premises data sources without the need to move the data. Query large datasets and take advantage of your existing investments. Get the flexibility you need to meet individual needs, and the needs of your organization.
One gateway for all your cloud services
Install once and deploy multiple on-premises data connections across Power BI, Power Apps, Power Automate, and Azure Logic Apps using the same gateway.
Простая настройка
Download and install the gateway with minimal interactions. Then sign in with your organization account to register the gateway to be used by cloud services.
Secured access to data
Data transfer between Power BI and the on-premises data gateway is secured through Azure Service Bus. Credentials provided by gateway administrators are encrypted to help protect your information in the cloud and only decrypted on the gateway machine.
| On-premises data gateway (standard mode) | Локальный шлюз данных (персональный режим) | |
|---|---|---|
| Совместимые облачные службы | Power BI, Power Apps, Azure Logic Apps, Power Automate, Azure Analysis Services, Dataflows | Power BI |
| Обслуживает нескольких пользователей с управлением доступом для каждого источника данных | | |
| Runs as an app for users who aren’t administrators | | |
| Runs as a single user with your credentials | | |
| Import data and set up scheduled refresh | | |
| DirectQuery support | | |
| Support for a live connection to Analysis Services | | |