Force query to run in the detail (DirectQuery) table in a Composite Model

[impro]

Hi,

Is it possible to force a query to run in the DirectQuery table instead of aggregate table in a composite model

Thanks

[GilbertQ · Accepted solution]

Hi @impro 

Yes this can be done when creating the table in the dataset, it should be created with a data source that can run DirectQuery.

Here are more details: Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs