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

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.

Presenter:
Abe Newton
Freelance Consultant
Fourth Stripe Solutions

Please join us in person or online at twitch.tv/techlahoma!

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