Michael on 08 Aug 2017 06:38:42
Currently you have to connect via gateway, but it would be much more convenient to be able to connect directly from PowerBI to Snowflake.
Administrator on 10 Jun 2021 18:50:31
Microsoft Idea · Snowflake connector -> add SQL statement as optional (powerbi.com)
- Comments (10)
RE: Connect to live data in Snowflake from the PowerBI.com service
i use an ODBC connector installed on a virtual machine with IFR environment installed. all queries from an azure sql database (read and write) run smooth and within seconds , I use azure synapse for that. on the other side , we have power bi reports that connect to snowflake via gateway. some reports may take suddenly 2 hour + to refresh. does not happen every day , but probably every week. there seems to be a queue building up quick if it gets busy. a beter approach is highly welkome. PS i would not use Snowflake but prefer all data/jobs just on azure , but ok, it was not my choice. the costs of snowflake are 1 K oer day, and growing . this is risky. the company turns around 3B while making 800M loss. i wonder if they exist over 5 years . stay on Azure if you can.
RE: Connect to live data in Snowflake from the PowerBI.com service
The on-premises gateway requirement has been been superseded now that the Snowflake SSO connector is available in public preview: https://www.snowflake.com/blog/using-sso-between-power-bi-and-snowflake/
RE: Connect to live data in Snowflake from the PowerBI.com service
I work for a fortune 500.... we're moving our data to snowflake. You better get this done or we'll be using Tableau.
RE: Connect to live data in Snowflake from the PowerBI.com service
This makes Power BI less than ideal when using Snowflake. We need this ASAP! Why would 2 cloud based systems need an "On-Prem Gateway"? That nullifies most of the benefits of using cloud solutions.
RE: Connect to live data in Snowflake from the PowerBI.com service
This is highly required feature. Hope will be resolved ASAP.
RE: Connect to live data in Snowflake from the PowerBI.com service
Is there any recent update on this? Would like to see if direct connector to snowflake is on a roadmap in next quarter.
RE: Connect to live data in Snowflake from the PowerBI.com service
Cant' believe is not there yet!
RE: Connect to live data in Snowflake from the PowerBI.com service
This is important feature for PowerBI with Snowflake implementations.
RE: Connect to live data in Snowflake from the PowerBI.com service
This is an important feature to make power bi useful with snowflake. Additionally Row level security management in snowflake would improve this feature.
RE: Connect to live data in Snowflake from the PowerBI.com service
Setting Gateway for each warehouse connection is a pain process.
We would love to have direct connection to snowflake from power BI