The on-premises data gateway. A crucial link in the chain for our Power BI Reports, yet so often overlooked. For many it’s a mysterious piece of technology that “just works”, until it doesn’t. And when it doesn’t, then what do we do?

We’ll dive into the underlying architecture of the on-premises data gateway, to understand what types of activities it does, and how they influence the overall performance and working of our end-to-end flow for Power BI Reports.

We’ll cover the options you have available to you to tweak and optimize some of the processes that make the on-premises data gateway tick, and make sure you’re aware of the options available to right-size the underlying machines.

But of course, once it’s all up and running, how do monitor it to make sure it’s in a healthy state? We’ll discuss some of the native options that are available to you, and what you can do to use these to your advantage.

When all is said and done, you should have new and improved insights in the inner workings of the on-premises data gateway, which options you have to optimize and tweak, how to plan for sizing, and some ideas for monitoring the overall health.