Forum Discussion
Disable Aggregation on Columns during Personalisation
I have a table visualisation with a number of filters affecting the rows displayed.
Even when the row count after filtering is as small as 60 rows, personalising the visual by adding a column and performing an aggregation (SUM or a COUNT) on this coulum results in "Resource Exceeded" error.
Is tehre a way to disable aggregation on columns as a quick fix?
Hoping , If it is table visual, you can click on the column in the Visualization pane and use do not summarize
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
If not, then add an index column to table and use that in visual on axis/row/details etc
2 Replies
- amitchandak
Super User
Hoping , If it is table visual, you can click on the column in the Visualization pane and use do not summarize
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
If not, then add an index column to table and use that in visual on axis/row/details etc