Get started with the On-Premises Data Gateway in Microsoft Fabric
HTML-код
- Опубликовано: 12 июн 2024
- 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.microsoft.com/data-inte...
On-premises data gateway architecture
learn.microsoft.com/data-inte...
Install an on-premises data gateway
learn.microsoft.com/data-inte...
📢 Become a member: guyinacu.be/membership
*******************
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/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#MicrosoftFabric #Gateway #GuyInACube 
Наука
Great revisiting the gateway again, it would be great to have a video for VNet Data gateway 101
I was also about to comment asking vnet Vs gateway
Confused on how the gateway knows where the sql database is located
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)
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
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
Thank you for your video. I followed all your steps one by one. But it still not working, Can you help me please ?
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?
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.
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?
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
It may help you : learn.microsoft.com/en-us/data-integration/gateway/service-gateway-proxy
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.
❤
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.
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"....