Performance improve- Refresh a part of fact table

[daominhtri]

I have a fact table that become larger every day. It is form website and take long time to pull and refresh. Is there any way to refresh a part of it only? For example only the record last 2 months refresh, the older 2 month record is not refreshed. Or any other way?

[v-yuta-msft]

Hi daominhtri,

You can use incremental refresh, click options-> preview features. For more details, please refer to this documentation.

 

Regards,

Jimmy Tao

[daominhtri]

I'm wondering if Power BI load the whole data from the website and then refresh or it just load the "hot" data only.