Loading...

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

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 Power BI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows

Published on:

Learn more
Chris Webb's BI Blog Chris Webb's BI Blog
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

Share post:

Related posts

Calculated Columns vs Measures in DAX

Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 whe...

1 day ago

Fabric Copilot to help write DAX queries improvements

This update comes with a marked improvement when generating DAX queries and conversationally editing them. This includes overall correctness o...

1 day ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy