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

Power BI Integration with GITHUB

While Azure DevOps is usually the easiest choice for Microsoft users, connecting Power BI to GitHub is becoming a must-have skill for anyone u...

4 hours ago

How I Built a Full Power BI Semantic Model in Minutes Using Agentic AI and GitHub Copilot

In this second part of my blog series, I will show you how I edited the required files and then created my semantic model by using the Agentic...

17 hours ago

A whirlwind tour on User-context-aware calculated columns in Power BI!

Bye, bye translation headaches! With the new User-context-aware calculated columns, we can tackle certain challenges more convenient than ever...

21 hours ago

Power BI Semantic Model Refresh Warnings

Since March 2026, Power BI semantic models have started showing warnings in their Refresh History in the Service. This has scared a few people...

2 days ago

🚀 Power BI for Beginners (2026): Complete Day 1 Guide to Start Your Data Analytics Career

30 Days of Power BI - Day 1 Introduction Your comprehensive journey to mastering Microsoft Power BI begins today. Transform raw data into act...

5 days ago

How to Set Up Agentic Semantic Model Development for Power BI Using GitHub Copilot on Windows

I was inspired and in awe after watching the video that Rui Romano posted in LinkedIn where Rui shared a video on how he used Agentic model de...

7 days ago

Agentic AI in Power BI and Fabric, Part 2: Getting Started with VS Code, GitHub Copilot, and Safe MCP Setup

A Personal Note Before We Continue Before I continue this series, I want to briefly share why it took me so long to publish this second blog. ...

9 days ago

Power BI And Support For Third Party Semantic Models

I’ve been working with Microsoft BI tools for 28 years now and for all that time Microsoft has been consistent in its belief that semantic mod...

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