Forum Discussion
How to append only changed data in powerbi desktop?
Hi,
IAm very new to powerbi.How to do incremental load in powerbi desktop means append only changed data to already existing data in powerbi desktop not in service,as i know incremental refresh is there but it only works in powerbi premium.How to do in powerbi desktop, as a bi developer loading incremental/changed data is a regular thing right.Why it is not there in powerbi desktop upto now or any workaround is there using edit query.
4 Replies
v-juanli-msftCommunity Support
I'm not clear about your requirement.
when data changing in source, refresh if from Power BI Desktop, it would append changed data under orignal data as below, right?
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi,
Thanks for your response,for your scenario i want the data like this
col1 col2
1 e
2 b
3 c
4 d
thanks & Regards
Seenu.
- v-juanli-msft
Indeed, when refreshing from Power BI Desktop, it would refresh to get the result you expected in Power BI.
But it is not an incremental refresh. It just reflects the whole new data from data source.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
