Forum Discussion

DanielNie's avatar
DanielNie
New Member
3 years ago
Solved

Load table from Dataverse and Countrow is different

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!

1 Reply