How to connect to the DaaS Platform through Power BI

Video

This 6 minute video shows the process of connecting to the DaaS platform via Power BI: https://www.loom.com/share/11a5668182ea4ed6af3e67993945bac5?sid=ab5648c6-9b8c-437d-b446-b799492e0cec

Chapters

0:00 - Introduction

1:22 - Authentication and Whitelisted IP Address

2:46 - Loading Models from the Council-Specific Warehouse

3:25 - Importing Data into Power BI

4:32 - Creating Relationships in the Model

Summary

In this video, Matt from GDATA, has a brief guide on how to connect to the DAAS platform through Power BI and load relevant models. 

Tutorial

To get started push the "get data" button from the top ribbon and select the Snowflake option. 

It is important to be on a whitelisted IP address as the process of getting data may not work if you are unrecognized. Furthermore the menu will have all the relevant options available. The below example focuses on the public analytics.

Make sure to choose import when prompted with the connection settings.

When you have successfully imported data Power BI will let you know it has been successfully imported and you will be taken back to the main page. Please refer to the video for best practice when creating relationships.