Similar as power bi dataflow

[Jocelyn]

hi team, morning! i would like to do something like this in the diagram ,however , i dont have premium version to access powerbi dataflow. May i know what is the alternative i can use to perform similar function ? Basically, i would like to 1) Appending Historical Data to New Data 2) refresh and provide real time update for new data with each refresh. Appreciate if you could share with me your thoughts

[Jocelyn]

hihi, the blog that you shared are solutions for users which has Paid version. Do you have alternate solutions using free version?

[v-yiruan-msft]

Hi @Jocelyn ,

You can try the second method which I refer in my previous post by using DAX UNION and disable the option “Include in Report Refresh”:

Incremental Load in Power BI using DAX UNION

Best Regards

[v-yiruan-msft]

Hi @Jocelyn ，

It seems that you are trying to add new data and only refresh the new data while keeping the historical data. Please check the content in the following links, hope they are helpful for you.
1. Configure incremental refresh

All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only

Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh

2. Use DAX UNION

Incremental Load in Power BI using DAX UNION

Best Regards