Power BI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows

Recently I was working with a customer using DirectQuery mode and where all traffic to the data source had to go through an on-premises data gateway for security reasons. They noticed that report performance got worse when traffic went through the gateway and this was particularly true when Power BI generated SQL queries that returned … Continue reading →

Published on: August 04, 2024

Learn more

Chris Webb's BI Blog Chris Webb's BI Blog

A blog about Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query, M, Power Map and Excel for BI

Chris Webb's BI Blog Chris Webb's BI Blog

A blog about Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query, M, Power Map and Excel for BI

Learn more

Power BI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows

Related posts

D25: Supplier with highest top 5 selling products | #25daysofdaxfridays challenge

Variance with DROP LINES in Power BI

D24: Supplier with highest category diversity | #25daysofdaxfridays challenge

D23: Supplier w most expensive product | #25daysofdaxfridays challenge

Important Update coming to R and Python visuals in Power BI

OneLake Integration for Power BI Semantic Models

D22: Suppliers w most out of stock products | #25daysofdaxfridays challenge

Easily Convert Your Power BI Report from Local File to Teams

D21: Suppliers that deliver more products than avg | #25daysofdaxfridays challenge

Reusing formatting for Power BI reports