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)
[Link] 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).
[Link] 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 [Link] 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.
[Link] 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
[Link] 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
[Link] 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
[Link] 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
[Link] 7/7