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
Another Way To Get The SQL Generated By Power BI DirectQuery Mode
If you’re performance tuning a DirectQuery mode semantic model in Power BI, one of the first things you’ll want to do is look at t...
1 day ago
Copilot in Power BI: Your AI-Powered Data Analyst
AI (Artificial Intelligence) has been dominating its impact everywhere and Microsoft Copilot in Power BI is the result of this – becoming a ga...
3 days ago
Industry Use Cases: Power BI and Dynamics 365 Business Central integration
Introduction Microsoft Dynamics 365 Business Central and Power BI together can completely alter how modern businesses operate. Therefore, in t...
4 days ago
Migrate Power BI Dataflow Gen1 to Fabric Dataflow Gen2
Unfortunately, there isn’t a migration tool to convert your Power BI dataflow (gen1) to Microsoft Fabric dataflow (gen2). If you have Fa...
5 days ago
Tips and Tricks for Integrating Power BI with Excel
Introduction Struggling to make sense of your data? You’re not alone. Many businesses find themselves are overwhelmed with information b...
5 days ago
Context transition in DAX explained visually
6 days ago