disaggregated Data

Hi everybody

I’m trying to create a table and, I don’t know why, I can’t disaggregate all the rows.

In the database, I have 7 rows with the same id, date,  description and value and I want that the table contains all the 7 rows. Instead, the table aggregate the information and only appears one line with the amount.

What I want

What I have

Noted that in the setting I have already set the variables to “not summarize”.

In order to overcome this issue I create a function “row_number”  but with this function my importing data settings through to “import” instead direct query”

Do you have another solution to this issue?

Thanks