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
Simplify Audit Log Export from Dataverse for Compliance and Governance Using Azure Synapse Link and Power BI
Audit logs are essential for enhancing security, meeting regulatory requirements, and monitoring changes made to business data within Microsof...
1 hour ago
Unlocking the Future: AI and Power BI Awaits!
17 hours ago
Why You Should Rethink Measure Tables in Power BI!
19 hours ago
Unlock the Hidden Powers of Power BI!
1 day ago