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.
3 Comments
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 TaoHi 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:
I have gotten this to pop up in other projects, but it will not work in this one.
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.
