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

Power BIは「つながる」より「どうつなぐか」で差が出ます。 同じソースでも、Import（取り込み）／DirectQuery（都度問い合わせ）／Live接続（モデル共有）で挙動は激変。 この記事では主要データソースを性能・モデリング・運用の観点で俯瞰し、使い分けの ...

This article targets data modelers developing Power BI DirectQuery models, developed by using either Power BI Desktop or the Power BI service. It describes DirectQuery use cases, limitations, and ...

If you use Power BI to connect to a data source such as SQL Server in DirectQuery mode, you’ll find that by default you cannot use the complete range of DAX functions inside your calculations. For ...

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

Following on from my last post covering DirectQuery in Power BI, I thought it might be interesting to take a look at the way MDX queries are supported in SSAS Tabular 2016 CTP3 DirectQuery mode. There ...