What is 'really really large' amounts of data - cannot be measured in row count (2 bn.) . Also - most grown up data models can't be flattened down to a single table. So, you'll end up importing 10-12 tables into import mode, replicating your data model and your data. Get your users hooked on import mode and your data grows and vertipaq and import mode chokes and you have to re-engineer. Paginated reports (ex SSRS) does not handle sharing the same imported dataset for 100s of concurrent users.
Awesome 👍 Looking for more from Chris Webb, his blog is just amazing. Thank you!!
This is great wondering if there is similar for import mode ?
You mean "Best Practices for Import Mode"?
Hope we see a direct query performance optimization techniques video
Very interesting. Thx
What is 'really really large' amounts of data - cannot be measured in row count (2 bn.) . Also - most grown up data models can't be flattened down to a single table. So, you'll end up importing 10-12 tables into import mode, replicating your data model and your data. Get your users hooked on import mode and your data grows and vertipaq and import mode chokes and you have to re-engineer. Paginated reports (ex SSRS) does not handle sharing the same imported dataset for 100s of concurrent users.