Power BI Gateway – Introduction Into Tool For Report Refresh/Update

Last modified date:

It is nothing hard to create report using Power BI desktop for example from Excel and then upload it to the cloud on powerbi.com. But how to update the cloud data when the source file is located on your PC/server and “the cloud service does not see the data”? One of the ways is to update the report manually in Power BI desktop, counting with uploading it to the web again afterwards. But that is not the most handy solution. The elegant solution is an automatic update using Power BI Gateway.

What is Power BI Gateway used for?

Simply put, it is a safe bridge between on-premise data (data on PC or server) and Power BI service. This bridge creates a connection between your report uploaded to Power BI service and data source (e.g. some Excel). If the source Excel is not changed afterward, the changes will get mirrored into the report.

Power BI gateway can be simply installed on your server/pc. Here is the link for download.

Power BI Gateway installer offers 2 gate types

You can select type of the gate during the installation – 2 options are available and it can be sort of confusing at the first glance

1) On-premises data gateway – preselected type meant for personal usage and mainly for servers. This gateway offers more options of use. Main benefit is multiple users can use it if installed on server. With according permit issued by gate admin of course.

2) On-premises data gateway (Personal mode) – second type is the easier personal mode. This gate is installed on PC and enables only updates of report done from account to which the gate is connected (does not allow multiple users to access the dataset). This option haves also more restrictions.

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Category: Power BI reporting Tags:

About Ing. Jan Zedníček - BI Developer, Finance controller

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.