Incremental refresh

[Anonymous]

Hello!

The first thing you want to verify after implementing incremental refresh is how many rows was refreshed right?

In Power BI Service, where can I see the number of rows loaded? The refresh history is only showing the duration..

Sincerely

Jan

[GilbertQ]

Hi @Anonymous 

You could also use DAX studio to connect your data set and then do the view metrics which would then show you how many rows you have in each partition.

[Anonymous]

Hi Gilbert

I am not sure. Just having to total number of rows in each partition will not answer the question on how many was actually reloaded. I have hundreds of thousends rows in each months of partition and expecting to only reload the latest two months according to how I did the incremental refresh setup. Now, the refresh takes more time than expected and I did want to verify the behaviour. 

Thanks

Jan 

[aj1973]

Hi @Anonymous 

You can add a measure to your report to COUNTROWS of last refreshed

[Anonymous]

I am not sure how you mean? What I am after is similar to what you get in a simple SQL update or in this case insert i.e. "X number of rows updated" or "X number of rows inserted" 

The incremental refresh is supposed to load all rows between RangeStart and RangeEnd parameters. The refresh is scheduled monthly and should just load the last month rows and not all of them. For me it seems that the meachnism seems to fail and all rows (months) are loaded... 

[aj1973 · Accepted solution]

@Anonymous 

In your desktop open the PBIX and create a DAX measure COUNTROWS(Table or coloumn) where you applied the incremental refresh filter by RangeStart and RangeEnd. Put the measure in a Card visual.