Power BI

Use Power BI Snowflake Connector to Visual Your Data

Build Power BI Snowflake Based Reports

In this post I will walk you through the steps required to use the Power BI Snowflake Connector to access data in a Snowflake warehouse.  If you are new either Power BI or Snowflake this will be a quick reference for you to make the connection and where to find the server name.

Step 1 – Open Power BI and then select Get Data to see the available data connectors.  Type “snowflake” in the search box to bring up the Snowflake connector as shown below.

Power BI Snowflake Connector Settings

Now you need to input the connection string and warehouse that you would like to connect to.  To determine your Snowflake instance, login to your Snowflake account and then navigate to your Warehouses.  In the screenshot below you can see the URL, copy the string to be used as the server name in the connector ending at snowflakecomputing.com.  My Snowflake instance is setup on Microsoft Azure so my server string looks like this:

For example server name –  zz123456.west-us-2.azure.snowflakecomputing.com

Warehouse name – COMPUTE_WH

Then hit Connect to proceed to the login screen.

Enter your Snowflake user and password.  When successful you will then see the databases and tables available for use in Power BI.

Select Tables from Snowflake in Power BI Desktop

Now that you are connected and authenticated, you will be able to select the data you want to visualize in Power BI.  Just like the other data connectors, a list of available database and tables are shown.  Select the objects that you need and then click Load.

Once connected, you can use the data just like any other data source such as add relationships, create new columns, measures.  Then start building your reports and data visualization in Power BI Desktop.

This completes the steps you need to use to access data with the Power BI Snowflake Connector.

CDO Advisors Power BI Consulting

At CDO Advisors we know you are the kind of people who want to allow your team to make business decisions based on clear data insights.  In order to be that way, you need online dashboards that enable data drive decisions.  The problem is your team doesn’t have the time and expertise to quickly build analytic dashboards, which makes you feel frustrated.  We believe everyone should have access to high quality automated dashboards that drive data insights and are available anywhere.

We understand the challenges leaders face transforming how they visualize and use their data.  That’s why we created the CDO Advantage where we build you amazing dashboards at an affordable price.  Here’s how it works we build you a custom online dashboard in 4 weeks or less.  Step 1 you provide us a data, Step 2 we design and deliver dashboards, Step 3 we publish the dashboards and setup automated refreshes.  Call us today,  so you can stop wasting time asking others for information and start actively monitoring and acting on critical metrics.

CDO Advisors Microsoft Power BI Solutions:

BI as a Service – Low Monthly Fees, Pay Per Month Per User

Executive Dashboards – Get Dashboards in 4 Weeks

Healthcare Dashboard Proof of Concept – SEE your data visualized

Microsoft Power BI Demo – Compare your current reporting to Power BI

Power BI Quick Start Solutions – Ready to start or enhance your Power BI?

Train Your Team – Remote Power BI Developer and End User Training

Use Power BI for Finance Teams – Learn how Power BI can improve operations

Virtual Chief Data Officer – Confused by all your data?  We can help

CDO Advisors YouTube – Subscribe and Watch Our YouTube Channel

Derek

I am the founder and CEO of CDO Advisors a data and analytics consulting and training company. We specialize in helping companies get more value from their data with high value low risk projects.I have been publishing articles and books for over 20 years on SQL Server, data and architecture.

Recent Posts

3 Business Views in Power BI You Need for Every Report

3 Business Views in Power BI I often see reports that were built in Power…

2 years ago

3 Power BI Governance Best Practices

3 Power BI Governance Best Practices As you get started with Power BI for reporting…

2 years ago

Complete Power BI Consulting Services

Power BI Consulting Services Get Power BI Consulting for 50% less than Big Firms I…

2 years ago

Power BI Data Quality Dashboard Examples

Power BI Data Quality Dashboard Examples Data quality is a problem for every company.  Legacy…

2 years ago

3 Secrets to Drive Power BI Adoption

The Secrets to Drive BI Adoption Drive Power BI adoption in your enterprise with these…

2 years ago

3 Common Power BI Adoption Issues

3 Common Power BI Adoption Issues I often see companies that have spent the time…

2 years ago

This website uses cookies.