Forum Discussion

PBI_RH's avatar
PBI_RH
Regular Visitor
3 years ago
Solved

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 e...
Need Help
GilbertQ's avatar
GilbertQ
Super User
3 years ago

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

  • PBI_RH's avatar
    PBI_RH
    Regular Visitor
    3 years ago

    thanks  a lot for the solution.