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
Microsoft Copilot (Microsoft 365): Power BI integration in M365 Copilot
This release enables M365 Copilot to reason over Power BI enterprise data and returns grounded answers directly from Power BI reports and sema...
12 hours ago
Using Fabric Operations Agents And Workspace Monitoring With Power BI
This week, in the announcement about support for Fabric Pipelines in Workspace Monitoring, I noticed that it came with an Operations Agent tha...
1 day ago
Power BI on a Mac: I Love It
4 days ago
I Put 11 Power BI Secrets to The EXPERT Test
4 days ago
Microsoft Viva: Create and customize Power BI reports
Microsoft Viva Insights will allow eligible users to create, customize, and save supported Power BI reports, including adjusting periods, filt...
7 days ago
The Benefits Of Using Direct Lake Mode In Power BI
This is a blog post I’ve been meaning to write for a long time. Since Fabric launched there has been a lot of focus on Direct Lake mode ...
8 days ago
Optimising DAX: Model Design Comparisons and Testing Tips
Star schema vs flat table vs header/detail - which Power BI model design gives you the best performance? This post compares all three and cove...
11 days ago