Power-BI + Synapse Synergies Demo
An easy to set up demos of Power BI + Synapse Synergies for performance and lower cost on massive data sets
![summary](https://github.com/stevemoss-microsoft/Power-BI---Synapse-Demo/raw/main/graphics/splash%20page.jpg?raw=true)
-
Download Dax Studio to assist with monitoring
https://daxstudio.org/
-
Create a Synapse Dedicated Pool.
https://docs.microsoft.com/en-us/azure/synapse-analytics/quickstart-create-sql-pool-studio#:~:text=Create%20a%20dedicated%20SQL%20pool%20in%20Synapse%20Studio,pool%20create%20wizard%20will%20appear.%20More%20items...%20
- Download and connect with SQL Server Management Studio
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-ssms#:~:text=%20To%20connect%20to%20Synapse%20SQL%20using%20dedicated,type%2C%20such%20as%20SQL%20Server%20Authentication...%20More%20
Demo documentation consists of 2 parts:
Setup: follow instructions on word document for setup.
Demo: follow instructions on word document for demo.
Power BI and Synapse Performance Layers:
![summary](https://github.com/stevemoss-microsoft/Power-BI---Synapse-Demo/raw/main/graphics/Power%20BI%20Dedicated%20Layers.jpg?raw=true)
Power BI Aggregations and Direct Query
![summary](https://github.com/stevemoss-microsoft/Power-BI---Synapse-Demo/raw/main/graphics/Power%20BI%20Aggregations%20and%20Direct%20Query.jpg?raw=true)