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

Free Power BI Starter Kit (PBIX + Excel + Roadmap) – Download & Start in 30 Minutes

If you’ve always wanted to learn Power BI but didn’t know where to start, this Free Power BI Starter Kit is the perfect first step. Whether yo...

3 days ago

How to Access a Former Employee’s Power BI “My Workspace” and Recover Reports

One of the common challenges I’ve seen in organizations is when a team member leaves and their Power BI reports are stored in their personal M...

3 days ago

Standalone Copilot in Power BI mobile apps: Chat with your data anytime anywhere (Preview)

We’re excited to announce the release of the Standalone Copilot experience in Power BI Mobile apps! Copilot in Power BI on mobile is a new way...

3 days ago

Bringing Context Aware Intelligence to Power BI

Ten years ago, Power BI entered the market and transformed how businesses interact with data. Before self-service BI, business users waited da...

4 days ago

Power BI November 2025 Feature Summary

The November 2025 Power BI feature update brings several important announcements and enhancements across the platform. Key highlights include ...

4 days ago

PBIR will become the default Power BI Report Format – Get Ready for the Transition

Starting in January 2026, all new reports created in both Power BI Service and Desktop will use the PBIR format by default, and existing repor...

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