User Profile

rakesh1810

Copper Contributor

Joined Oct 20, 2022

2 Posts

View All Badges

User Widgets

Recent Discussions

Re: Power Query , refresh data changes
I tried using self-referencing but when I used split the column to row function the referencing is not coming properly, The values get duplicated every time i refresh as there is no unique column in both tables
Oct 21, 2022 Place Excel
2.6KViews
0likes
1Comment
Power Query , refresh data changes
There is a source table ( https://sobha-my.sharepoint.com/:i:/g/personal/rakesh_krishnappan_sobhaconst_com/EVK9nRqcRH9JmIa_Qt8kf-gB59Z6x8YO4ZDWgmxYu7v9LQ?e=5v7Sy4 ) The data from the source is imported to another sheet in the same excel file using power query, with the filter of the column to text ( to row ) ( https://sobha-my.sharepoint.com/:i:/g/personal/rakesh_krishnappan_sobhaconst_com/EYheTvTgv_tDhe0dhi3XIIwBMv3l3ooiB1M2Oy1fY3pLig?e=dMwe2w ) There are two additional columns manually added to the imported table ( https://sobha-my.sharepoint.com/:i:/g/personal/rakesh_krishnappan_sobhaconst_com/EQjXnLpi4X9JryJhTZZW3L0BxmnfwPZwP3j-dGmQ0M3gZQ?e=mZ3gfp ) The data are manually filled in the additional column ( https://sobha-my.sharepoint.com/:i:/g/personal/rakesh_krishnappan_sobhaconst_com/EcYV-6MG7vhCkkfyRiQMjikByvZyV17c7wjMKLxVfmvFnA?e=NY83XA ) When there is new data updated in the source file ( https://sobha-my.sharepoint.com/:i:/g/personal/rakesh_krishnappan_sobhaconst_com/EblhAEi5VJ1Bikjh3wL1WYYBRPeB1r8bFbtHzGDPL7AR5w?e=weGj13 ) and when the power query is refreshed, the last entry made in the additional column gets changed and is coming in the last row of the refreshed table ( https://sobha-my.sharepoint.com/:i:/g/personal/rakesh_krishnappan_sobhaconst_com/EeToaSQDBVNAn2T1wvt85tABowliJqqvtwiPe20SD9cRIw?e=Kv1EfR ) i don't want the manually entered data to get changed to the last row of the refreshed table
Oct 21, 2022 Place Excel
excel
power bi
2.7KViews
0likes
3Comments

Recent Blog Articles

No content to show