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

Подписаться 435 тыс.

Просмотров 7 тыс.

50% 1

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

Наука

Опубликовано:

12 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@dhawalpmehta 18 дней назад

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

@MrSparkefrostie 18 дней назад

I was also about to comment asking vnet Vs gateway

@MasterCamus 15 дней назад

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

@MrSparkefrostie 18 дней назад

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)

@DanielWeikert 18 дней назад

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 18 дней назад

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 18 дней назад

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 18 дней назад

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.

@Dipakbohora 11 дней назад

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.

@diegoscalionitp 18 дней назад

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 18 дней назад

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 14 дней назад

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

@Yasmine-ug8lu 17 дней назад

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

@anilkapkoti296 18 дней назад

❤

@VaidasMatkus 10 дней назад

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 10 дней назад

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"....