Forum Discussion
Aggregation manage issues
1. Do you have any direct query mode table in your model? If not then, can you please exaplain what is your expectaion from manage aggregations feature. "Manage aggregations" is used to improve the performance of a large direct query based semantic model. Please refer this document
https://learn.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced
2. Error message indicates
"There is another aggregation with the same summary and detail table/column combination.
If you set an aggregation for a table, it is automatically hidden." is it the case? If not, can you check if the error goes away after selecting the detail table from the drop down?Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
1. Do you have any direct query mode table in your model? If not then, can you please exaplain what is your expectaion from manage aggregations feature. "Manage aggregations" is used to improve the performance of a large direct query based semantic model. Please refer this document
https://learn.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced
2. Error message indicates
"There is another aggregation with the same summary and detail table/column combination.
If you set an aggregation for a table, it is automatically hidden." is it the case? If not, can you check if the error goes away after selecting the detail table from the drop down?
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Thanks for your reply.
So the aggregations manage menu is only able to be selected and changed when there is a relation between a Direct Query table to the (aggregated) Import table. I am following a Power BI course and set up a Import to Import table to test aggregation tables and particular the manage aggregation menu..
Error message indicates
"There is another aggregation with the same summary and detail table/column combination.
If you set an aggregation for a table, it is automatically hidden." This is indeed the (translated) case. After setting up the tables I am not able to change the detail table drop down and detail column drop down in the manage aggregations menu.Thanks for your reply.
So the aggregations manage menu is only able to be selected and changed when there is a relation between a Direct Query table to the (aggregated) Import table. I am following a Power BI course and set up a Import to Import table to test aggregation tables and particular the manage aggregation menu..
Error message indicates
"There is another aggregation with the same summary and detail table/column combination.
If you set an aggregation for a table, it is automatically hidden." This is indeed the (translated) case. After setting up the tables I am not able to change the detail table drop down and detail column drop down in the manage aggregations menu.
