Search code examples
powerbipowerbi-desktopsummarizationno-data

Power BI is requiring at least one column to be summarized to display data

I am trying to create a simple Power BI report to embed within an application. The purpose of this report is to simply display the rows that are being passed into it via Direct Query. However, if I disable the summarization of all of the columns the report refreshes with no data being displayed. Re-enabling summarization on one column causes the data to reappear. I do not require any summarization for the report and am wondering how to disable or circumvent this behavior.

Report with Summarization of one column

enter image description here

Report without Summarization of one column

enter image description here

Solution

  • It turns out that what I really wanted to do was turn off the "Totals" footer which is an option in the "Format" tab of the visual itself. See https://radacad.com/removing-the-total-value-for-a-column-in-the-table-visual-of-power-bi-using-isfiltered for more information.