Тёмный

What the HECK is a Power BI Gateway Cluster? 

Guy in a Cube
Подписаться 438 тыс.
Просмотров 35 тыс.
50% 1

Confused about what a Power BI Gateway cluster is? Have your On-Premises Data Gateway installed but it's overloaded? This video is for you!
Documentation: docs.microsoft.com/data-integ...
PowerShell: docs.microsoft.com/data-integ...
📢 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/
#PowerBI #Gateway #GuyInACube

Наука

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

 

13 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 27   
@shashankp3351
@shashankp3351 4 года назад
I am working on gateway from last 1 year but not aware on how exactly gateway clustering need to be setup & work but your video on this really helped me a lot to clarify all my doubts.Thanks You so much. Also it would be great help if you can start creating videos on admin activities like how to use activity log to get audit data,Usage activity,Identify gateway server load,How to decide gateway server configuration,Capacity management.It will really help.Thank You.
@serolrom
@serolrom 4 года назад
+1 on this request for videos about management and admin activities!
@exnuke1972
@exnuke1972 2 года назад
Great work!!.. Your videos are helping me get our instance ready for production. Thanks
@muralikrishna9786
@muralikrishna9786 4 года назад
Implemented couple of Months back after we were facing multiple failures. It was really helpful. It's worth mentioning even though it's a basic one . In a real case scenario, make sure ports are opened to access the on prem data sources from both Gateway machines.
@terpstry
@terpstry 4 года назад
Great video! Didn't realize before that I could set up a Gateway cluster. Reassuring option ;-)
@GuyInACube
@GuyInACube 4 года назад
Glad it helped! Thanks for watching! 👊
@adrismisra5407
@adrismisra5407 2 года назад
Thank you, this is awesome.
@govindkulkarni1584
@govindkulkarni1584 4 года назад
Hi Adam, This is great in terms of organizations having huge amount of reporting done. Sharing the load will lead to better performance. However just wanted to confirm if we are adding another gateway to existing cluster(anchor gateway) can we have 2nd gateway property changed to be anchor gateway(i.e. making 2nd gateway primary one).
@chuyvarela3113
@chuyvarela3113 4 года назад
I have the same question as Kazim Raza... do Data Sources get created only ONCE at the Primary Gateway or do we need to duplicate them onto the Secondary?
@RamsesKZ
@RamsesKZ 4 года назад
@Guy in a Cube, can we have a multi-region gateway cluster? Like, if one enterprise gateway will be assigned to EAST-US and another one to CENTRAL-US? Does that depend on the premium region/power bi home region?
@krunchu
@krunchu 4 года назад
As usual, awesome stuff, and this time with improved video. A couple questions though. 1 - so we don't have to establish data sources in both the data gateways, correct? Data sources paths will be picked up by the fail over gateway automatically. 2 - How can we add existing gateways to the cluster? Is there a PS cmdlet? Thanks Kaz
@serolrom
@serolrom 4 года назад
1.- In the Power BI service you see just the whole cluster as a single entry, so you set up each data source only once, and the routing through your various machines in the cluster is transparent to you. 2.- Besides availability of a PS command (sorry I don't have it available right here right now), you can enter the machine and execute the gateway installation software. From it, you can assign said gateway to an existing cluster. EDIT: I have not tested assinging an already existing gateway to a different cluster, I don't know what would happen with any existing data source already configured. But the gateway installation software, in addition to the actual installation of a gateway, it has also an option to migrate, etc. I bet you would use that option and you'd get guidance on the process.
@abeworldforever
@abeworldforever 4 года назад
is the 60 FPS a new thing? so smooth !
@rohitgupta8319
@rohitgupta8319 4 года назад
Hi Adam. Many thanks for the Video. Just need to clarify that , do I need map data source on both the gateway cluster ?
@peggyyuen7859
@peggyyuen7859 4 года назад
Hi Adam, Great video! I have set up a second gateway on a separate VM, but during install I didn't check the box to put it under the existing cluster, how can I add that now stand-alone gateway to the cluster? Thanks!
@Virupaksha1503
@Virupaksha1503 3 года назад
Hey Adam, Thats a great video, just one question, suppose the gateway is up and running but underlying database goes down, in this scenario, will other gateway be used. Also, what if both databases are hosted on same machine, can we configure databases instead of machine names. Thanks in advance for your response.
@rkelleg
@rkelleg 4 года назад
Hi Adam, I'm also a little bit confuse about the usage of the gateway in the enterprise. 1) How can the users who publish their reports use the gateway. Do I need to set them as administrator of the gateway, or do I have to go through all their dataset to connect their data ? 2) WHat is the best practice for the credentials on dataset via gateway ? Users cannot use their own , as passwords change every 3 months. Do you use a "powerreader" kind of user ? thanks in advance
@beaddy101
@beaddy101 3 года назад
Awesome
@dragomirpetrov5062
@dragomirpetrov5062 2 года назад
Thanks for a good video! A bit of a long question: Can a cluster hold 2 gateways from different regions, let's that the primary gateway and cluster are located in West Europe and the second gateway is in North Europe? The scenario here is that initially the idea was to generate PBI report based on AAS. The Azure resources are in West Europe but for some reason the PBI environment is in North Europe. So the Azure gateway installed in order to link the AAS and the Azure DB is in West Europe. But now there is a need for a PBI report that fetches data from the Azure DB in West Europe through db import, but the gateway cannot reach the PBI region. Currently the dilemma is if the gateway should be re-installed but set in North Europe and risk a bit of latency or install a second gateway for North Europe in order to be able to refresh these few "import-reports"? Thanks in advance!
@visheshjjain
@visheshjjain 3 года назад
Please can you do a video on how to convert a gateway to a Primary Gateway in the same cluster. Thank you!
@guyinazo
@guyinazo 4 года назад
Do you and Patrick play Borderlands? Your latest thumb nails look like artwork from the game :)
@saharazeem5588
@saharazeem5588 4 года назад
Oh wow new look of vedio and superb vedio
@GuyInACube
@GuyInACube 4 года назад
Thanks! 👊
@1904archie
@1904archie 4 года назад
We have 8 enterprise gateways and two cluster gateways. My question is do we need cluster gateway for each enterprise gateway or can I club multiple gateways under one cluster gateway?
@Crockdaddy1074
@Crockdaddy1074 4 года назад
Not sure if you guys will see this comment, but I am curious. I am setting up a Power Bi Cluster in AWS, normally I'd expect to put a Load Balancer in front of any clustered resource but I kinda get that is not the case with the Power Bi Gateway. I am guessing you just define your servers in the client making the connection to the gateway and also registering the Power Bi Gateways to Azure. If you or anyone happens to know please comment or link docs to it. I've searched and searched but no clear answer.
@MartensRonald
@MartensRonald 3 года назад
Does the cluster rollback to the primary gateway when that one is online again?
@RoshanJhamca
@RoshanJhamca 3 года назад
Copy of kanchana movie, ye bollywood wale copy karna kab chodenge
Далее
The Power BI Gateway   All You Need to Know
20:19
Просмотров 47 тыс.
Using Single Sign-on with the Power BI Gateway
12:46
Просмотров 28 тыс.
КАК ДУМАЕТЕ КТО ВЫЙГРАЕТ😂
00:29
Почему худеют от Оземпик?
00:37
Просмотров 319 тыс.
Handling MULTIPLE fact tables in Power BI
9:02
Просмотров 299 тыс.
VNET Data Gateway
8:23
Просмотров 8 тыс.
APPLE дают это нам БЕСПЛАТНО!
1:01
Просмотров 515 тыс.
899$ vs 360$ which one will you choose ? #iphone #poco
0:18