'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
Report without Summarization of one column
Solution 1:[1]
You really need to include key columns of the data feed to be sure you are displaying the rows as they come from the Direct Query. If the data feed doesn't have key columns or an index, you can generate one in SQL. Here's an example from an Oracle DB:
SELECT ROW_NUMBER() OVER (ORDER BY column1) AS "Index",
column1, column2, ... columnN from table_name
Including the keys or an index will ensure you see every row in the table.
Solution 2:[2]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | TheRizza |
| Solution 2 | jamesamuir |