Forum Discussion
User Defined Aggregations - Direct Query with Power BI Dataset and Azure AS
Hi all, Is it possible to create a user-defined aggregation from a Power BI dataset/Azure Analysis Services model connected via DirectQuery? It seems like the option is available to use (as a...
Aggregation tables are supposed to be based on import mode.
My aggregation table is imported into my model - the rest of the tables in my model (including my main Fact table) are using DirectQuery mode. Isn't that how user-defined aggregations are supposed to work? Or am I misunderstanding something?
That is correct - in the vast majority of scenarios. There are corner cases where you need to do it the other way round.
If the query engine didn't engage the aggregation table then you must have some query filters that interfere.
This article may help User-defined aggregations - Power BI | Microsoft Learn