Billion Row Dashboard – Working with Direct Query vs Import - Abe Newton

This is a past event

13 people went


We’ll explore some of the different techniques for creating dashboards based off of billion row source tables. In doing so we’ll explore the 3 different techniques PowerBI offers for retrieving source system data; Import, Direct Query and Dual mode. We’ll explore the queries that are sent to the source system (SQL Server in our case) when using Direct Query. We’ll also look at how both SQL Server and PowerBI store the data.

Abe Newton
Freelance Consultant
Fourth Stripe Solutions

Please join us in person or online at!

Join our online Slack community by agreeing to follow the code of conduct and submitting your email address at More information is at You can find us in the #databases and #okcsql channels!