Dataset Incremental Refresh - Append only or update/insert

[PBI_RH]

Hi Everyone,

Our ETL load data daily. I setup PBI dataset incremental refresh based on colume "ETL load time". Basically dataset append

today's data only. 

I just found out that at the end of each month, the KPI columns will be updated for everyday in the whole month. 

Sep 1st load

001, 2022-09-01,  100

Sep2  incremental load,  adding one row

001, 2022-09-01,  100

002, 2022-09-02, 120

...

...

Sep 30 incremental load, adding one row for sep30, also need to update KPI values for all the rows. 

001, 2022-09-01,  105

002, 2022-09-02, 128

....

030, 2022-09-30, 230. 

=========================

QQ: could you please let me know if it can be done by incremental load or I have to use full refresh?

[GilbertQ · Accepted solution]

Hi @PBI_RH 

If you are using Power BI Pro you would have to do an entire dataset refresh.

If you are using Power BI Premium or Premium Per User you could then use the XMLA end point to then refresh the partitions needed.

Here is an example from my blog post where you can use Power Automate to complete this: Using the Power BI Async REST API to refresh a partition with Power Automate (Using an HTTPS URL) - ...

[PBI_RH]

thanks  a lot for the solution.