Forum Discussion
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.
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
1 Reply
- pratyashasamalMemorable Member
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