Forum Discussion
Dataset Incremental Refresh - Append only or update/insert
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?
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) - FourMoo | Power BI | Data Analytics
2 Replies
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) - FourMoo | Power BI | Data Analytics
thanks a lot for the solution.
