Need to concatenate/show refreshed values

[Anonymous]

Hi Mentors,

Looking for a solution for the below problem. 

I have a value which is changed for every refresh. Upto this, it is fine. THis value is coming from a POST method. So, I am able to manage it using Power query post methid.

Now I need to concatenate this new values every time and display. Like, first time I am getting "a7" and next time I am getting "b9" and again after refresh I am getting "g3". I need to show these values. I can concatenate these values or I can show them as table rows.

Any help is much appreciated.

[smpa01 · Accepted solution]

@Anonymousyou can write a powershell script to store your dataset upon each refresh in a folder to archive and then query the folder and compare the archived value.

[Anonymous]

Thanks Jimmy....Its pretty helpful. Just one question, can it be possible to do using Power Query? I was trying with Table.insertrow but so far no result.

[Jimmy801]

Hello @Anonymous 

what would you like to do? As I was writing that incremental refresh in Power Query is not possible at all. So every time you hit the refresh-button, your data is recalculated and therefore you loose all your previous data.

BR

Jimmy

[Anonymous]

Hi Jim, understand. Actually I was trying to insert the refreshed value to another table after each and every refresh. Trying to do it using Power query but again, as you already said, its not possible.

Thanks for your help.

[Jimmy801]

Hello @Anonymous 

this is not possible with Power Query. Every time you refresh, your dataset is completely recalculated, and you miss the data from a previous refresh

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy