Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Manage Aggregations won't open upon clicking.

When I click on Manage Aggregations on my agg table nothing happens. 

For my model I have a details table as a direct query that uses M parameters, then two supporting tables as dual, and a aggregation table as import. My data source is SQL Server and all of my tables use native queries. 

I have tried many things such as updating Power BI Desktop, deleting and recreating my tables, using power query to create the aggregation table, but nothing is working. No matter what I do, when I click on Manage Aggregations, nothing happens. I am not sure what is wrong. 

kyoder_0-1689773864904.png

 

 

Status: Needs Info
Comments
Anonymous
Not applicable

Hi @kyoder 

Manage Aggregations dialogue ? Can you explain it in detail ? The merge you're talking about generally operates inside PQ, so I don't really understand what you mean.

 

Best Regards,
Community Support Team _ Ailsa Tao

kyoder
Regular Visitor

Hi @Anonymous 

I am refering to what pops up when you click on Manager Aggregations in the model view. 

So, when I am in model view, I click on the three ellipeses on the aggregate table, then click on Manage Aggregations. Then nothing happens. 

This is what is supposed to pop up:

kyoder_0-1689855943758.png

I have gotten this to pop up in other projects, but it will not work in this one. 

criztina14
Frequent Visitor

has this been solved? I'm having the same problem, my query also runs in directquery mode, I want to create an aggregation but manage aggregations window doesn't show up.