「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) ...

In the first part of this series I showed how to create a Power BI DirectQuery dataset connected to Log Analytics to do near real-time monitoring of Analysis Services activity; in the second part I ...