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.
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