4/8/24, 5:43 PM Connect Power BI to Azure Synapse Serverless SQL pool | by Valentin Loghin | Feb, 2024 | Medium
Open in app
Search Write
Connect Power BI to Azure Synapse
Serverless SQL pool
Valentin Loghin
3 min read · Feb 20, 2024
In my previous article Azure Synapse Analytics integrate Data Lake, I
presented how to query a Data Lake using Azure Synapse Serverless SQL
Pool. Azure Synapse workspace enables us to create a SQL Database on top
of a Data Lake, but this isn’t managed by Spark. In this type of database, we
can only use a serverless SQL pool.
In this follow-up to the previous article, I’ll show you how to connect Power
BI desktop to the Synapse serverless SQL pool.
Step 1— Get the Serverless SQL Pool Workspace SQL endpoint: Starting from
Synapse Analytics workspace, click Manage(1), SQL pools(2), Built-in(3),
copy Workspace SQL endpoint (4)
https://medium.com/@valentin.loghin/connect-power-bi-to-azure-synapse-serverless-sql-pool-2be7a69914e3 1/7
4/8/24, 5:43 PM Connect Power BI to Azure Synapse Serverless SQL pool | by Valentin Loghin | Feb, 2024 | Medium
Step 2— Open Power BI Desktop application on your computer
Step 3— Choose Azure Synapse Connector: Home(1), Get data(2), Azure
Synapse Analytics SQL(4), Connect(5).
https://medium.com/@valentin.loghin/connect-power-bi-to-azure-synapse-serverless-sql-pool-2be7a69914e3 2/7
4/8/24, 5:43 PM Connect Power BI to Azure Synapse Serverless SQL pool | by Valentin Loghin | Feb, 2024 | Medium
Step 4 — For Server provide the SQL Serverless Pool URL (from Step 1) and
click Ok
Here are the differences between selecting Import and DirectQuery:
Import: The dataset is imported into Power BI and as you create or
interact with a visualization, Power BI uses the imported data.To see
underlying data changes since the initial import or the most recent
refresh, you must refresh the data, which imports the full dataset again.
DirectQuery: No data is imported or copied into Power BI, rather as you
create or interact with a visualization, Power BI queries the underlying
data source, so you’re always viewing current data.
Step 5 — Sign in Microsoft account and Connect
Step 6— Select the tables you want to analyze and chose Load.
https://medium.com/@valentin.loghin/connect-power-bi-to-azure-synapse-serverless-sql-pool-2be7a69914e3 3/7
4/8/24, 5:43 PM Connect Power BI to Azure Synapse Serverless SQL pool | by Valentin Loghin | Feb, 2024 | Medium
Now you can work with the new created Power Bi datamodel and build the
reports you desire.
Power Bi Azure Synapse Analytics Serverless Reporting
https://medium.com/@valentin.loghin/connect-power-bi-to-azure-synapse-serverless-sql-pool-2be7a69914e3 4/7
4/8/24, 5:43 PM Connect Power BI to Azure Synapse Serverless SQL pool | by Valentin Loghin | Feb, 2024 | Medium
Written by Valentin Loghin Edit profile
60 Followers
Data Engineer & Data Architecte
More from Valentin Loghin
Valentin Loghin Valentin Loghin
Connect Microsoft Fabric Connect Snowflake Tables with
Lakehouse with DBeaver DBeaver
In this quick guide I will show you how to In this quick guide I will show you how to
connect to Microsoft Fabric Lakehouse usin… connect to Snowflake Tables using DBeaver.
3 min read · 6 days ago 2 min read · Mar 20, 2024
Valentin Loghin Valentin Loghin
Medallion Architecture in Data Medallion architecture in Microsoft
Lakehouse with Delta Lake and… Fabric
What is a medallion architecture? What is a medallion architecture?
9 min read · Feb 15, 2024 11 min read · Feb 1, 2024
118 18
See all from Valentin Loghin
https://medium.com/@valentin.loghin/connect-power-bi-to-azure-synapse-serverless-sql-pool-2be7a69914e3 5/7
4/8/24, 5:43 PM Connect Power BI to Azure Synapse Serverless SQL pool | by Valentin Loghin | Feb, 2024 | Medium
Recommended from Medium
Sajjad Hussain in Cloud Believers Ramya Munagala
Data Transformation Unleashed: A HR Analysis
Deep Dive into Azure Data Factory Introduction: Unlocking insights from raw
Introduction data is akin to solving a captivating puzzle. A…
· 9 min read · Apr 1, 2024 6 min read · 2 days ago
14 10
Lists
General Coding Knowledge ChatGPT
20 stories · 1092 saves 21 stories · 555 saves
Leadership Modern Marketing
48 stories · 288 saves 106 stories · 538 saves
Janvigupta Arthur Steijn
"From Messy to Masterpiece: The Merge Delta Lake tables with Azure
Ultimate Power BI Dashboard… Functions (delta-rs + polars)
Why Does Dashboard Design Matter? Imagine a scenario where you want to create a
delta table, but you don’t have access to a…
4 min read · Mar 20, 2024 5 min read · Jan 29, 2024
119 12
https://medium.com/@valentin.loghin/connect-power-bi-to-azure-synapse-serverless-sql-pool-2be7a69914e3 6/7
4/8/24, 5:43 PM Connect Power BI to Azure Synapse Serverless SQL pool | by Valentin Loghin | Feb, 2024 | Medium
DataSculptsInsights in Microsoft Power BI Kamireddy Mahendra in Towards AI
Data Profiling in Power BI A Data Analysis Project — Coffee
Introduction Shop Sales Analysis.
The Objective of any data analyst is to find the
hidden insights in the data and come out wit…
4 min read · Mar 31, 2024 6 min read · 6 days ago
15 58 2
See more recommendations
https://medium.com/@valentin.loghin/connect-power-bi-to-azure-synapse-serverless-sql-pool-2be7a69914e3 7/7
