Load table from Dataverse and Countrow is different

[DanielNie]

Hi all,

i`m a newbie and i`m trying to get my first report done. So i loaded a table from Dataverse with a date filter:

( Table.SelectRows(dbo_myTable, each Date.Year([myTable_datum]) > 2021)

i tried also with a datetime function:

Table.SelectRows(myTable, each [datum] > #datetime(2021, 12, 31, 0, 0, 0).

When i click on save and take over, i can see that PowerBi (or the Power Query) is loading around 46200 rows.

I added a card with a measure:

(# Count rows myTable = COUNT(myTable[Datum]) or i tried also with Countrows(myTable) ),

but this card shows me only 35540 rows. 

I did create a similar "card"(Label) in a PowerApp (CountRows(Filter(FAKT_SUBs; Datum > DateTime(2021; 12; 31; 0; 0; 0))) and i get the correct result of 46433 rows.

What might be wrong? Any help appreciated!

[pratyashasamal · Accepted solution]

Hi @DanielNie ,

I had understanded what you mean, about your problem, I think this involves the compression mechanism of the original data by Power BI.

You can refer to the articles.

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction 

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C