Тёмный
No video :(

PBIMCR - Direct Query with Chris Webb 

Ben Howard
Подписаться 2,8 тыс.
Просмотров 8 тыс.
50% 1

In DirectQuery mode Power BI does not store any data inside a dataset but instead runs queries against your data source to get the data in needs when a report is rendered. It's very powerful - but you can easily run into performance issues if you do things the wrong way. In this session you'll learn the best practices for using DirectQuery mode in Power BI: how data should be modelled, which properties and settings are important, and when you should use composite models and aggregations.
Chris Webb is a ..
specialist in Power BI, Analysis Services, MDX, Power Pivot, DAX, and Power Query. He's been blogging about Microsoft BI for over 10 years, and racked up over 1500 posts.! He also speaks at a number of conferences including SQLBits, the PASS Summit, the PASS BA Conference, SQL Saturdays and user groups.

Опубликовано:

 

29 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 6   
@Bharath_PBI
@Bharath_PBI Год назад
Awesome 👍 Looking for more from Chris Webb, his blog is just amazing. Thank you!!
@laionegan
@laionegan Год назад
Very interesting. Thx
@yugen4070
@yugen4070 Год назад
Hope we see a direct query performance optimization techniques video
@charlesdelanoy
@charlesdelanoy Год назад
This is great wondering if there is similar for import mode ?
@BenHoward_PowerBI
@BenHoward_PowerBI Год назад
You mean "Best Practices for Import Mode"?
@asadm540
@asadm540 Год назад
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.
Далее
Chris Webb - Fabric Direct Lake Deep Dive
52:35
Просмотров 3,4 тыс.
🛑самое грустное видео
00:10
Просмотров 167 тыс.
Power BI Masterclass: Data Modeling 101
56:54
Просмотров 55 тыс.
Power BI on Databricks Best Practices
50:51
Просмотров 13 тыс.
Formula engine and storage engine in DAX
25:50
Просмотров 23 тыс.
Power BI Composite and Hybrid Models
50:51
Просмотров 3,4 тыс.