Parallel Loading of Tables with Power BI & Azure Synapse Analytics
Andy In this blog I'm continuing my series about using Power BI and Azure Synapse Analytics together and the features between the 2 platforms that are useful. The first blog covered…
Understanding ResultSet Caching in Dedicated SQL Pools with Power BI
Welcome to this new blog series in which I'll be diving into both Power BI and Azure Synapse Analytics features that can work together. These features are not exclusive between…
Azure Analysis Services Migration to Power BI Premium
Around November 2022, Microsoft announced a new feature within Power BI which allows you to migrate Tabular models from Azure Analysis Services into Power BI Premium. This interested me as…
Connecting Power BI to Azure SQL Database using Private Endpoints
This was originally posted on my Datahai company blog in November 2021. This blog has now been updated as of November 2022 as certain steps have changed, notably the movement…
Dedicated SQL Pools DMVs: Show Name of Synapse Studio Script Being Executed
I'm currently in the process of building a Query and Workload Analyser Power BI report which queries several DMVs (Dynamic Management Views) in Synapse Dedicated SQL Pools. One of the…
Mastering DP-500 Exam: Integrating Microsoft Purview with Power BI
Part of the upcoming Azure Enterprise Data Analyst Associate exam, the DP-500, is to understand how Microsoft Purview integrates with Power BI to manage assets. In this blog post we'll…
Integrating Power BI & Azure Synapse Analytics – Power BI UK User Group
Here is the link to the slides for the Power BI UK User Group session on Thursday 17th March, 2022 here. The video recording should be available soon.
Power BI Hybrid Tables with Synapse Analytics Serverless SQL Pools
In this video we're talking a look at the new Power BI Hybrid Tables feature which combines Import, Incremental Refresh, and DirectQuery (real-time) modes in a single table. We look…
PASS Data Community Summit Companion Resources
PASS Data Community Summit 2021 Slides Please click here for a PDF copy of the slides. Polaris (Serverless SQL Pools Engine) Please click here to download the Polaris whitepaper to…
Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 4 of 4 – Connecting Power BI to the Dimensional Model
Welcome to Part 4 in the Creating a Logical Data Warehouse with Synapse Serverless SQL Pools series. We are now looking at connecting Power BI to Serverless SQL Pools to…