Forum Discussion

TMJForrester's avatar
TMJForrester
Icon for Advocate II rankAdvocate II
3 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Aggregation tables are supposed to be based on import mode.

  • TMJForrester's avatar
    TMJForrester
    Icon for Advocate II rankAdvocate II
    3 years ago

    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?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      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