Is an On-Premises data gateway as secure as a SHIR used in ADF? From testing, Data Gateways are much more of a hastle (npgSQL, SSL, ...) the SHIR. Will SHIR support come to Fabric?
Hi. Can we use "Windows" authentication method for SQL server, if the Power BI report is connecting to SQL with Direct Query mode? Or is it restricly has to be "Basic" authentication?
Question, I’ve been trying to connect to a Direct Query source through my gateway which shows as “Analysis Services’ on my list of sources but I can’t figure it out and it won’t connect. Any advice gratefully received!
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
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?
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
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?
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)
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?
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.
Hi, I have a problem when I try to configure my connection gateway. Said something about my credentials. When I choose basic authentication, what username and password do I need to use? I'm using Windows authentication in my SQL server. So, I don't use any password
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.
Hi Im having a issue with mine. MY gateway is on a VM machine on AWS. I am able to connect to the data source and all but when i add it to a Gen2 Dataflow, i am able to see the table preview but my refresh always fails? with this error: There was a problem refreshing the dataflow. Please try again later. (Request ID: 0b7a297c-c13f-4e35-a55b-bc761427ab07). i am not sure why this is?
Hello Sir, My company has enterprise sql license and i am planning to install Power BI report server and migrate the existing SSRS RDL files and create some power bi dashboards , We dont have fabric or power BI service but we have few Power Bi pro licenses for the users and developer(me) , Do we still need On-prem gateway to share the reports between developer and the end users ? If we dont then how the data refresh tales place in the background ? Could you please explain? , Thank you
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"....
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
Is an On-Premises data gateway as secure as a SHIR used in ADF?
From testing, Data Gateways are much more of a hastle (npgSQL, SSL, ...) the SHIR.
Will SHIR support come to Fabric?
Hi. Can we use "Windows" authentication method for SQL server, if the Power BI report is connecting to SQL with Direct Query mode? Or is it restricly has to be "Basic" authentication?
question which one is more secured? using this gateway or using private endpoint?
Question, I’ve been trying to connect to a Direct Query source through my gateway which shows as “Analysis Services’ on my list of sources but I can’t figure it out and it won’t connect. Any advice gratefully received!
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'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?
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
Hi,excelent video!! Can I change the Region of the gateway once installed?
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?
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)
Shoudn't the email address associated with the PowerBI Gateway be a ServiceAccount? and would that service account require a PowerBi Pro License?
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?
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.
Hi, I have a problem when I try to configure my connection gateway. Said something about my credentials. When I choose basic authentication, what username and password do I need to use? I'm using Windows authentication in my SQL server. So, I don't use any password
IT WAS GREAT ! I made it thanks.
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.
is it good standard to use OnPremise Gateways ?
Thank you
Thank you for your video. I followed all your steps one by one. But it still not working, Can you help me please ?
Do the gateway still works when i turn off laptop ?
no
@@Cordycep1 so u have any ideas to make it run 24/7 ? do i have to install it on a server or somethings ?
@@baophan259 yes must have a dedicate server running .
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"
Each gateway creates a standalone cluster. When you create a second gateway, select that section you bypassed and add it to the one you already have.
@cybertron2600 thank you
Why you changed 9:18 windows connection username in authentication method? What username and password do i use?
I have the same problem. Did you solve that puzzle? 😅
Hi
Im having a issue with mine. MY gateway is on a VM machine on AWS. I am able to connect to the data source and all but when i add it to a Gen2 Dataflow, i am able to see the table preview but my refresh always fails? with this error: There was a problem refreshing the dataflow. Please try again later. (Request ID: 0b7a297c-c13f-4e35-a55b-bc761427ab07). i am not sure why this is?
Hello Sir, My company has enterprise sql license and i am planning to install Power BI report server and migrate the existing SSRS RDL files and create some power bi dashboards , We dont have fabric or power BI service but we have few Power Bi pro licenses for the users and developer(me) , Do we still need On-prem gateway to share the reports between developer and the end users ? If we dont then how the data refresh tales place in the background ? Could you please explain? , Thank you
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"....
❤