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 moreRelated posts
Unlock the Future of Data with AI and Power BI!
3 hours ago
Visualizing RATING Score in Power BI
11 hours ago
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
Unlock the Secrets to Power BI Mastery!
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