User-defined aggregations with PowerBI Datasets in Direct Query

[stephiemomo]

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 an example, I have a report connected to an AAS model via DQ, a separate aggregation table imported, and the "Manage Aggregations" option works like normal). But after running a trace in DAX Studio's Server Timings tab to test my aggregation, the query trace doesn't show that a match was found. I've tried the aggregation with both defined relationships and GroupBy columns, but no such luck.

Has anyone tried using aggregation tables with DirectQuery for PBI datasets/AAS before? Or is this only available for traditional DQ sources like SQL Server?

@GuyInACube 

[v-stephen-msft]

Hi @stephiemomo ,

You can mix data from imported patterns with data from Direct Query. Please refer to the composite models in Power BI Desktop,

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.