On-premises data gateway planning

Planning for the On-premises data gateway involves identifying which data sources require a gateway and understanding the role of the gateway in each deployment scenario. For example, if an import mode Power BI dataset or an import mode Azure Analysis Services model simply needs to be refreshed with on-premises data every night, then gateway resources (hardware) should be provisioned to support this specific nightly workload. This deployment scenario, with the refreshed and in-memory data model hosted in the cloud, is preferable from a user experience or query performance standpoint, as the queries generated in the Power BI service do not have to access the on-premises source via the On-premises data gateway. ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.