The Power BI Gateway All You Need to Know

Power BI is a data analysis tool that connects to many data sources. Suppose the data source for Power BI is located in an on-premises location. In that case, the connection from the cloud-based Power BI Service to the on-premises located data source should be created with an application called Gateway. In this post, you will learn what the Gateway is, the types of the gateway, their differences, installing the gateway, and scheduling a data set with that gateway.
To learn more, read my blog article here:

[samp_sampath]

Thanks for the comprehensive Explanation. Do we need Power BI gateway for Oracle Fusion DB Connection?

[rikabchand]

Thanks for the video? If we need the gateway only for the on-premises database then how security is taken care when we connect to the database which is in cloud? Please explain

[VladimirPetronic]

What about if I have two clusters and my Power BI report use one source from first cluster and another source from the second cluster?
I tried but the report wouldn't refresh - is this limitation? Reports could use only
one cluster?

[veeek]

Thank you, great video, lots of detail

[ARUN-kqdt]

Hello Sir,

We need clarity about the gateway, In our organization we use VPN for DB, So If the admin can create a report in powerBI means they are using VPN at that time. At that time only the remaining can see the report otherwise its showing error in the report.

[avprc]

Can the on-prem gateway be installed on AWS or GCP?

[kartikwat]

Great video indeed.
I have setup the gateway on my laptop connecting to the on prem sql database.

The gateway is running properly.
However, I am getting an error "On-premise data gateway failed to impersonate the user" while doing power bi dataset refresh.

Struggling to understand where I am going wrong.

[ramchandramishra]

Hi, We are using on-premise PBI data gateway. The gateway is keep stopping automatically after every 2-3 days. How to find the root cause of this issue.

[visheshjjain]

I have my SQL database in AWS RDS.
Is there some way to avoid using the gateway altogether, apart from hosting the database in Azure or using OneDrive/Sharepoint?

[aminkhalifeh]

I watched the whole video a couple of times. but I could not find my answer.

I have a problem now with my gateways. We have different customers with their workings spaces on Power BI that we want to connect their datasets on Power BI to their databases to Exact Online. The datasets are available through an On-premises gateway.

But when they are scheduled to be refreshed, the one that the credentials are applied works but if it happens at the same time with another dataset through the gateway it does not work and one of the datasets does not ger refereshed. My question is, do I have to create different gateways for every customer and working space or I can have one gateway for all of working spaces?

[monubhaiya]

do we need gateway for direct query SQL ?as its kind of live connection

[zeytecc]

The credentials are validated and able to fetch data on Power BI desktop, but the credentials are not validated on service side and thus not able to refresh the data when I type me windows user name and password how can I fix that???😊

[qzckwiy]

I have a dataset stored in a PostgreSQL database and have successfully created a Power BI dashboard. However, I am encountering challenges while setting up the gateway in the Power BI service. The issue arises due to an additional layer of security in the form of a VPN that we use to access the database. How can I establish a connection between Power BI service and the PostgreSQL database considering the presence of VPN security?

[Wzxxx]

Do u have any idea what is going here (i am going crazy):
Gateway set on account #1. I use its connection for MySql query and Sharepoint on my dev account. Both connections are organizational. I made a dataflow in a Pro workspace with above mentioned connections. It can’t be refreshed due to the fact that these sources cannot be used in single query. It is ridiculous. It works in regular power query. Morover same dataflow works and can be refreshed in premium workspace. No logic behind the error. Any ideas?

[mytdexter]

Nice exaplanation. 👍👍👍👍
Do I need a gateway to connect AWS RDS AWS RDS to Power BI service?
Also can you please do a video about how to connect AWS RDS to Power BI service?

[alirezamogharabi]

آقا دست شما درد نکنه، فقط اینکه همه جا رو توضیح مفصل دادین اما بخش اصلی ساخت گیت‌وی رو سرویس رو با اسلاید فرمودین که خیلی مشخص هم نبود، مثلا اسم کلاستر رو موقع تعریف گیت‌وی چی بدیم؟ ممکنه من رو سیستم لوکال اصلا کلاستر نداشته باشم و فقط گیت‌وی رو کانفیگ کرده باشم؟

[marcofernandez]

watched your Gateway videos... but still can't get the connection to mySQL working :(

[bumpyjslim]

What if i already have an API Gateway (Tyk or Kong gateway) in my infrastructure. What are the considerations / added values to add the Power BI Gateway in my infrastructure?

[ndatasolutions]

Nice Video, are you related to Tej Lavani, you look like twins