Guidance for deploying a data gateway for Power BI Power BIThis article provides guidance and considerations for deploying a data gateway in your network environment. A gateway is software that facilitates access to data that resides on a private, on premises network, for subsequent use in a cloud service like Power BI. This article walks you through the deployment, and provides guidance for, the On premises data gateway setup. For more about On premises data gateway, including a link to install it, take a look at the blog post. Before getting too far into the details of installation and deployment, there are a handful of considerations you should keep in mind. The following sections describe important things to keep in mind. Number of users. The number of users consuming a report thats using the gateway is an important metric in deciding where to install the gateway. Here are some questions to consider Are users using these reports at different times of the day What types of connections are they using Direct. Query or Import Are all users using the same report If users are all accessing a given report at the same time each day, youll want to make sure you install the gateway on a machine thats capable of handling all those requests see following sections for performance counters and minimum requirements that can help you determine this. There is a constraint in Power BI that allows only one gateway per report, so even if a report is based on multiple data sources, all such data sources must go through a single gateway. However, if a dashboard is based on multiple reports, you can use a dedicated gateway for each contributing report, and thereby distribute the gateway load among those multiple reports that contribute to that single dashboard. Connection type. Power BI offers two types of connections, Direct. Query and Import. Not all data sources support both connection types, and many reasons may contribute to choosing one over the other, such as security requirements, performance, data limits, and data model sizes. You can learn more about connection type and supported data sources in the list of available data source types section of the On premises data gateway article. Depending on which type of connection are use, gateway usage can be different. For example, you should try to separate Direct. Query data sources from Scheduled Refresh data sources whenever possible assuming theyre in different reports and can be separated. Doing so prevents the gateway from having thousands of Direct. Query requests queued up, at the same time as the mornings scheduled refresh of a large size data model thats used for the companys main dashboard. Heres what to consider for each For Scheduled Refresh depending on your query size and the number of refreshes occurring per day, you can choose to stay between the recommended minimum hardware requirements or upgrade to a higher performance machine. If a given query is not folded, transformations occur on the gateway machine, and as such, the gateway machine benefits from having more available RAM. For Direct. Query a query is be sent each time any user opens the report or looks at data. So if you anticipate more than 1,0. More CPU cores will result in better throughput for a Direct. Query connection. The requirements for a machine on which you install an On premises data gateway are the following Minimum. NET 4. 5 Framework. Windows 7 Windows Server 2. R2 or laterRecommended 8 Core CPU8 GB Memory. Windows 2. 01. 2 R2 or laterLocation. The location of the gateway installation can have significant impact on your query performance, so try to make sure your gateway, data source locations, and the Power BI tenant are as close as possible to each other to minimize network latency. To determine your Power BI tenant location, in the Power BI service select the About Power BI. Monitoring gateways. There are a few tools that you can use to monitor the use and performance of your installed gateways. Performance counters. There are many performance counters that can be used to evaluate and assess activity occurring on the gateway. The counters can help you understand whether you have large volume of activities by the specific type, which may prompt you to deploy a new gateway. Note. These counters will not capture specific task duration time. The gateway counter, in addition to your machines counters, provide you with an idea of how much load your machine is handling, and can provide an indication of whether the server resource capacity is becoming stretched or exceeded. These counters can be accessed from Windows Performance Monitor, and can be consumed by any reporting tools you use for this purpose. InformationWeek. com News, analysis and research for business technology professionals, plus peertopeer knowledge sharing. Engage with our community. A threat analyst at the cybersecurity firm Mandiant has been hacked and the attackers are claiming to have lurked on his computer for a year, collecting his login. Latest trending topics being covered on ZDNet including Reviews, Tech Industry, Security, Hardware, Apple, and Windows. In Microsoft Dynamics AX 2012, when a purchase order is product receipt and vendor invoice updated for stocked items, there are two accounting processes. Crack Pdf Creator 10. The onpremises data gateway acts as a bridge, providing quick and secure data transfer between onpremises data data that is not in the cloud and the. This article provides guidance and considerations for deploying a data gateway in your network environment. A gateway is software that facilitates access. Dynamics Ax 2012 R2 Partner Source Login Microsoft' title='Dynamics Ax 2012 R2 Partner Source Login Microsoft' />For a detailed walk through of how to use the gateway performance monitor with Power BI, take a look at the following community create blog post. Logs. Configuration and service logs provide another dimension on whats happening with your gateway. Always check your gateway logs when your connection is not working as expected, as not all error messages are surfaced on the Power BI service. An easy way to view all the log files on your local machine is to use the Export Logs button on the On premises data gateway when you re open the gateway after the initial installation is complete, and then select iagnostics Export Logs. Additional logging. By default the gateway performs basic logging. If youre investigating gateway issues, and need more information about query connection details, you can temporarily enable verbose logging to gather additional log information. To do this, in the installed gateway select Diagnostics Additional logging. Enabling this setting likely will increase the log size significantly, based on gateway usage. Its recommended that once youre done reviewing the logs, you disable Additional logging. Its not recommended to leave this setting enabled during normal gateway usage. Network configuration. The gateway creates an outbound connection to the Azure Service Bus. The gateway communicates on the following outbound ports TCP 4. The gateway does not require inbound ports. Prerequisites CRM 2016 online Portal SharePoint Online CRM Online 2016 With System Administrator. This is a blog site owned by Microsoft Dynamics AX CIR team with a focus on providing useful user guides, selfhelp materials as well as tips and tricks around. Gmail is email thats intuitive, efficient, and useful. GB of storage, less spam, and mobile access. Scroll down for Load balancing ADC information including Free Trials, Expert Videos Webinars, HowTos, Product Reviews, Case Studies and Technical Articles. All required ports are listed in the above list. It is recommended that you whitelist the IP addresses, for your data region, in your firewall. You can download list of IP addresses, which are found in the Microsoft Azure Datacenter IP list. That list is updated weekly. The gateway will communicate with Azure Service Bus using the specified IP address, along with the fully qualified domain name FQDN. ZVKiZuYe3Q/VLdFwg1T8zI/AAAAAAAAAtI/uqt8fg3ZQY0/s1600/7.png' alt='Dynamics Ax 2012 R2 Partner Source Login Microsoft' title='Dynamics Ax 2012 R2 Partner Source Login Microsoft' />If youre forcing the gateway to communicate using HTTPS, the gateway strictly uses FQDN only, and no communication will occur using IP addresses. Forcing HTTPS communication with Azure Service Bus. You can force the gateway to communicate with the Azure Service Bus by using HTTPS, instead of direct TCP. Doing so will slightly reduce performance. You can also force the gateway to communicate with the Azure Service Bus by using HTTPS by using the gateways user interface beginning with the March 2. To do so, in the gateway select Network, then turn the Azure Service Bus connectivity mode. Y49sdw23EvI/U3Ndh3EXWSI/AAAAAAAAAI8/yzT7xa-nnUg/s1600/04-InformationSource.jpg' alt='Dynamics Ax 2012 R2 Partner Source Login Microsoft' title='Dynamics Ax 2012 R2 Partner Source Login Microsoft' />On. Additional guidance. This section provides additional guidance for deploying and managing gateways. Avoid having a single point of failure. If possible, distribute your on premises data sources across several gateways in this case, if one machine becomes unavailable, youll still be able to refresh portions of your data, and not lose that functionality completely.