Hi Tejashri
The refresh action wont update the data with new rows but there is an action in the vbo called "Change pivot table data source" or something similar. You will need to use this to include the latest data range you want to capture. If it changes regularly and you need your bot to dynamically update the source then you can add a few action stages to find the new number of rows then use that to set the range for the data source.
Hope this helps
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
#MVP