Forum Discussion
User-defined aggregations with PowerBI Datasets in Direct Query
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?
1 Reply
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.
