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.
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!