GitHub

directquery-model-guidance.md

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 ...
crossjoin.co.uk

DAX Functions, DirectQuery And Unrestricted Measures

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

desktop-use-directquery.md

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

データの粒度とデータのインポート方式を検討する

当ページをご覧いただきありがとうございます。 詳細な分析をするためにはデータの粒度が細かい必要があります。売上であれば販売伝票明細単位であったり、野球のデータであれば、打者一人打席1球ごとの情報であったり、製品であればその製品を構成 ...
crossjoin.co.uk

First Look At SSAS 2016 MDX On DirectQuery

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