Forum Discussion
Power BI Report Builder - wants aggregates
Anonymous wrote:
So nothing has worked so far - why does Report Builder want something aggregated when everything comes from the same table, and how can I get around this?
If all you have on your report is a single rectangle then Report Builder is trying to display the result of all the rows in the resultset in this single rectangle and the only way to do this is to apply some sort of aggregate function.
If you want a row in your report for each row in your table then you need to drag a table control onto your report and then put the values you want inside a row in this table object. The report server table control will generate an output row for each row in your dataset. If you want you can put a rectangle inside your table control and layout your text boxes however you want, but the table control needs to be the outer object so that it can generate the repeating rows in the report output.
Super User
Anonymous wrote:
So nothing has worked so far - why does Report Builder want something aggregated when everything comes from the same table, and how can I get around this?
If all you have on your report is a single rectangle then Report Builder is trying to display the result of all the rows in the resultset in this single rectangle and the only way to do this is to apply some sort of aggregate function.
If you want a row in your report for each row in your table then you need to drag a table control onto your report and then put the values you want inside a row in this table object. The report server table control will generate an output row for each row in your dataset. If you want you can put a rectangle inside your table control and layout your text boxes however you want, but the table control needs to be the outer object so that it can generate the repeating rows in the report output.
Thanks d_gosbell - it was the table control I was missing.