「KPIはサクサク、でも“明細の穴”もすぐ見たい」。この要求に一発で応えるのが**Composite（Import＋DirectQueryのハイブリッド）**です。**集約テーブル（Import）**でダッシュボードを速くし、詳細テーブル（DirectQuery）で“今”を深掘る。設計のカギはAggregations ...

#customer intent: As a Power BI user, I want to understand how to use DirectQuery in Power BI Desktop so that I can connect to data sources without importing data and always view current data in my ...

My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure SQL DB and Synapse) ...

The new DAX window functions (announced here, more details on Jeffrey Wang’s blog here and here) have generated a lot of excitement already – they are extremely powerful. However one important benefit ...