PowerBI
Power BI is a cloud-based data analysis tool, which can be used for reporting and analysis of data from your chosen data warehouse.
Connect to Snowflake
If you have Snowflake, you should follow the steps below to connect your dashboard to the data warehouse.
![Power bi connect to data .png 1915](https://files.readme.io/e303258-Power_bi_connect_to_data_.png)
Click on the 'get data' arrow.
![click on more.png 302](https://files.readme.io/b316a47-click_on_more.png)
Click on more.
![search for snowflake.png 767](https://files.readme.io/c4c95a3-search_for_snowflake.png)
Then, search for Snowflake.
![introcude snowflake creds.png 887](https://files.readme.io/5e81054-introcude_snowflake_creds.png)
Introduce the credentials (server sometimes also called hostname and warehouse). When you connect for the first time, it might ask for some other credentials like user and password.
![select desired snowflake tables.png 1118](https://files.readme.io/e2e3b20-select_desired_snowflake_tables.png)
From here, you can navigate to the required schema, and select the tables that you need to use in your isualisation.
Connect to Redshift
![Power bi connect to data .png 1915](https://files.readme.io/0e6e2f9-Power_bi_connect_to_data_.png)
Click on the 'get data' arrow.
![click on more.png 302](https://files.readme.io/4a0807b-click_on_more.png)
Click on more.
![search for redshift.png 770](https://files.readme.io/1624f14-search_for_redshift.png)
Search for Redshift.
![connect to redshift.png 886](https://files.readme.io/85bd2ef-connect_to_redshift.png)
Add credentials for the server and database. When connect for the first time, it might ask for user name and password too.
![select desired snowflake tables.png 1118](https://files.readme.io/c5f204c-select_desired_snowflake_tables.png)
Navigate to the desired schema and select the tables you need for analysis.
Updated about 1 year ago