The types of data sources (relational database, analytic database, data feeds, or files).The number of concurrent dataset refreshes.Reliable, fast, and consistent connectivity is important to ensure report users have responsive experiences.ĭetermining the correct sizing for your gateway machine can depend on the following variables: Usually there's much less demand for CPU than is required by the Cache data workload-especially when it's required to transform data for caching. This workload requires CPU resources for routing queries and query results. For more information about DirectQuery, see Dataset modes in the Power BI service (DirectQuery mode).For more information about Live Connection, see Datasets in the Power BI service (Externally-hosted models).Generally, query results are small in size. The Power BI service sends queries, and the gateway responds with query results. The Live Connection and DirectQuery workload works mostly in pass-through mode. Live Connection and DirectQuery workloads Transfer: Data is transferred to the Power BI service-a reliable and fast Internet connection is important, especially for large data volumes.In this case, the gateway will consume more CPU and memory resources. When it's not possible, transformations must be done by the gateway. Whenever possible, the Power Query mashup engine pushes transformation steps to the data source-it's known as query folding. Data retrieval and transformation: Data is retrieved, and when necessary, transformed.Connection: The gateway connects to source data.The Cached data workload retrieves and transforms source data for loading into Power BI datasets. It's important you first understand these workloads before we discuss gateway sizing and recommendations.
The on-premises data gateway supports two workloads. It can be installed on a server on-premises, or VM-hosted Infrastructure-as-a-Service (IaaS).
The gateway is required whenever Power BI must access data that isn't accessible directly over the Internet.
#Microsoft power bi desktop system specs install#
This article targets Power BI administrators who need to install and manage the on-premises data gateway.
0 kommentar(er)
