Forum Discussion
Power BI service to Snowflake connection
- Hi there
The Power BI Team recently updated how you can connect to Snowflake which is allowing this to now work
Here are the blog post details: https://powerbi.microsoft.com/en-us/blog/announcing-enhanced-connectivity-for-snowflake/
Super UserIt is possible because Power BI see's the data source as a cloud connection and when it is a cloud connection it does not need the gateway.
I would say without having the gateway it is better because there is nothing for you to manage in terms of having to look after the gateway or the connections. And possibly faster because it is managed by Power BI and does not have to go via your On-Premise network.
Super UserHey Anonymous ,
I totally agree with everything GilbertQ mentioned already.
Maybe you want to consider using an enterprise gateway, because then it's possible to whitelist a single ip (namely the ip of the gateway machine) or multiple ips if you are using a gateway cluster.
Even if all our services are in azure in the same data center, there are certain datasets that require ip white-listing (requirements these datasets have to meet from a compliance and security perspective), and for this, we are using an enterprise gateway. There is a price we have to pay - performance. But this is something that we are willing to pay.
But as always, it depends.
Regards,
Tom
Hi TomMartens and GilbertQ
Thank you for your help
The point I am not able to understand is - Our snowflake is in AWS ( Not Azure) - So why does power BI considering snowflake as a cloud source. . The only possiblity I am seeing is that our snowflake is using "Azude AD" authentication ; so is there a poccibility that the communcation ports between snowflake(AWS) and Power BI service( Azure ) are already open?
- GilbertQHi there
The Power BI Team recently updated how you can connect to Snowflake which is allowing this to now work
Here are the blog post details: https://powerbi.microsoft.com/en-us/blog/announcing-enhanced-connectivity-for-snowflake/GilbertQ but is this in general availability ( and not preview) And will miccorsoft provide support?