Power BI Desktop - Data refresh

[Anonymous]

Hi all,

I have a table in Power BI that has currently 65 million rows. The data flows into PBI from Postgres DB.

The same table has been updated to 27 million rows ie., I've deleted redundant data from the database table. Now when I refresh the data manually for that table from PBI desktop will it have exactly 27 Million rows or will it just append any new rows on top of the 65 million rows? Hope this makes sense.

[v-lili6-msft]

hi @Anonymous 

PBI desktop will have exactly 27 Million rows, the refresh is a global update for all the data with your datasource.

Regards,

Lin

[Anonymous]

Hi @v-lili6-msft - But that was not the case. The number of rows increased to 71 Million after the refresh. The refresh was not global it was only for one specific table.

[v-lili6-msft]

hi @Anonymous 

It is a global update for all the querie that in edit queries, when you refresh, it will refresh all the queries which are in edit queries.

By the way, Incremental refresh is also supported in power bi.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Regards,

Lin