Skip to content

Integrating Power BI with Azure Synapse Analytics Serverless SQL Pools

Photo of Bob Duffy
Hosted By
Bob D.
Integrating Power BI with Azure Synapse Analytics Serverless SQL Pools

Details

  • Online Session* Click link to join at 19:00

With the power of Azure Synapse Analytics Server less SQL Pools we are able to connect to and process data stored in Azure Storage, Azure Data Lake Gen1 and 2, and Cosmos DB using familiar SQL commands.

How do we report on and visualize this data using Power BI? Are there optimization techniques we can use?

In this session we'll be covering the following:

  1. Creating an Azure Synapse Analytics environment
  2. Creating a Server less SQL Pools database
  3. Connecting to CSV and Parquet data stored in Azure Data Lake Gen 2 using Server less SQL Pools
  4. Using Power BI to connect to Server less SQL Pools to visualize this data in real-time.
  5. Optimization techniques to improve performance and reduce cost

-Andy Cutler-
I am an Azure Data Platform professional working predominantly with Azure Synapse Analytics (SQL Pools), Data Factory, SQL Server and Power BI. I hold an MSc in Business Intelligence and Data Mining.

Photo of SQL Ireland User Group group
SQL Ireland User Group
See more events