Skip to main content

Power BI

Completed

Connect to live data in Snowflake from the PowerBI.com service

Vote (159) Share
Michael's profile image

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.

Comments (10)
Michael's profile image Profile Picture

Maxim Ivashkov on 30 Jan 2025 10:17:34

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.

Michael's profile image Profile Picture

Craig Collier on 06 Jul 2020 00:11:36

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/

Michael's profile image Profile Picture

John Meagher on 06 Jul 2020 00:06:23

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.

Michael's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:48

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.

Michael's profile image Profile Picture

Heba Varkey on 06 Jul 2020 00:00:06

RE: Connect to live data in Snowflake from the PowerBI.com service

This is highly required feature. Hope will be resolved ASAP.

Michael's profile image Profile Picture

Bhavana Chirumamilla on 05 Jul 2020 23:58:30

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.

Michael's profile image Profile Picture

Alex Gonzalez on 05 Jul 2020 23:49:01

RE: Connect to live data in Snowflake from the PowerBI.com service

Cant' believe is not there yet!

Michael's profile image Profile Picture

Power BI User on 05 Jul 2020 23:44:45

RE: Connect to live data in Snowflake from the PowerBI.com service

This is important feature for PowerBI with Snowflake implementations.

Michael's profile image Profile Picture

Murtuza Morbiwala on 05 Jul 2020 23:39:53

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.

Michael's profile image Profile Picture

Sagar Bhatia on 05 Jul 2020 23:35:09

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