Get started with the On-Premises Data Gateway in Microsoft Fabric

Trying to leverage on-premises data? Can't connect to a cloud source because of firewalls or private networks? Learn how you can use the On-Premises Data Gateway with Microsoft Fabric to get the data you need!
What is an on-premises data gateway?
learn.microsof...
On-premises data gateway architecture
learn.microsof...
Install an on-premises data gateway
learn.microsof...
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#MicrosoftFabric #Gateway #GuyInACube

[@dhawalpmehta]

Great revisiting the gateway again, it would be great to have a video for VNet Data gateway 101

[@MrSparkefrostie]

I was also about to comment asking vnet Vs gateway

[@FranciscoGonzalez-dj9wm]

Hi,excelent video!! Can I change the Region of the gateway once installed?

[@Chizearl]

question which one is more secured? using this gateway or using private endpoint?

[@chrislupton7521]

Can the OPDG be installed on Win Server 2019? It cites it in its min specs on the MS tech doc, but it also states it needs TLS 1.3 - which afaik is Win Server 2022 min only?

[@MrSparkefrostie]

Some thoughts, maybe venting, you cannot use this gateway in normal ADF pipelines (it uses its own integration runtime) but can in fabric ADF pipelines....what is great here vs the above is being able to turn off nodes, i cant find a similar option in the runtimes from above..... lastly is personal gateways blockable somehow (asking for a friend)

[@santiagoescobar22]

Why you changed 9:18 windows connection username in authentication method? What username and password do i use?

[@peterdaniels3428]

I'm curious how this interacts with Express Route. Does it work? What needs to be configured in order for the OPDG to utilize the Express Route for comms?

[@DanielWeikert]

Question would be why the personal gateway which no one working in a company can ever use, is the only one which supports python for power bi? I will never understand that. Maybe you could address Egress charges with Shortcuts. That might be a bigger point as well. br

[@MrSparkefrostie]

I suspect security, if anyone could run any python script on that pc, you could have issues. On the flip side, python environments, if the python version is updated by another user and breaks your code....ok I suspect venv gets around the issue but I suspect you wouldn't need to run a venv just for this likely simpler script

[@sandeepbarge4699]

Why do we need gateway for accessing files in Amazon S3 bucket? These are available on another cloud and not on premise. Hence the question. Did I miss something?

[@diegoscalionitp]

If I understood correctly, the Gateway can be leveraged to transpose network barriers. Like if your resources are inside a VNet and a direct connection with S3 would not be possible. But the gateway has the permission to get it trough.

[@diegoscalionitp]

Q: If my internet provider has a firewall, may I need to configure some ports in order to get the gateway online within the Fabric?

[@MrSparkefrostie]

I speak under correction, I do not believe you need any port forwarding but you will likely need to open ports if you are only allowing specific ports, I recall it working 100% without anything special at least in personal mode

[@ray_an_e]

It may help you : learn.microsoft.com/en-us/data-integration/gateway/service-gateway-proxy

[@MasterCamus]

Confused on how the gateway knows where the sql database is located

[@monapanah]

IT WAS GREAT ! I made it thanks.

[@diegolagossilva700]

Hi! Diego from Chile, and my question is : if i have Azure but that Azure sql is in another account different to my personal company account fabric, how i connect ? and is necesary the gateway?

[@Vuyiswamb]

is it good standard to use OnPremise Gateways ?

[@kcwilsonii]

Shoudn't the email address associated with the PowerBI Gateway be a ServiceAccount? and would that service account require a PowerBi Pro License?

[@Dipakbohora]

I need your guidance on how to assign the same source file from two different computers to a Dashboard Report published in Power BI Service. The scenario involves having the source file on Computer A and Computer B, and I want the dashboard to update when I make changes to either source file using an on-premises gateway. I have Installed the Power BI Desktop on Computer A but not on Computer B.

[@lisarae7212]

How can you create a cluster after the gateway has been created. I have already bypassed the section that says "Add to an existing gateway cluster"

[@Yasmine-ug8lu]

Thank you for your video. I followed all your steps one by one. But it still not working, Can you help me please ?

[@anilkapkoti296]

❤

[@VaidasMatkus]

Using pipelines copy from on premise server to Lakehouse converts time zone to UTC. This issue is not resolved for about two months, Microsoft knows about it and seems to ignore it. Be careful! The bug only occurs using pipeline, it works using Dataflows gen2 without this problem.

[@VaidasMatkus]

Oh, and the problem is when date value is stored in SQL server, as "YYYY-MM-DDT00:00:00", and it is already in UTC - the value in Lakehouse is bad. Example, if i have date value in on prem server as 2024-06-21T00:00:00, in on prem i would get that 2024-06-20T21:00:00 as it just automatically assumes that my date/time is in on premise server local time zone and converts to "UTC"....