Power BI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows
Chris Webb BI
AUGUST 4, 2024
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 hundreds of thousands of rows.
200 
Let's personalize your content