- Make sure you have the credentials to your Snowflake reader account. If you have never set them, or you have forgotten them, they can be set or reset from your Connect platform, from the top bar, under the user menu > Snowflake settings section.
- Enter Power BI and, from Get data menu, search for Snowflake and select it as your data source. You can find an example in this article: Power Query Snowflake connector - Power Query | Microsoft Learn.
- To establish the connection, your tool will ask you to provide some details, such as the server URL, the warehouse name and your Snowflake account credentials. You can get all the needed information from Connect platform's top bar, under the user menu > Snowflake settings section.
Tip: When introducing the name of your Snowflake server in Server field, remember to copy the url without the "https://" part.
- Once the connection is established, your tool will ask you to choose the view you wish to connect to from the list. Under Custom Space > Public schema you'll find the complete list of the views available in your organisation's account.
- Power BI is now able to retrieve the data directly from the warehouse. It will now ask you to decide whether you prefer to query the warehouse directly or import the data first. We recommend the import option for most cases, but we encourage you to watch the following webinar where both methods are compared, the setup process is shown step by step and where you can find some best practices to improve the performance of your reports: Build Scalable BI Solutions | Microsoft Power BI.