Forum Discussion
Fixing visuals
Hello
If I change the colum header in source excel data sheet, visuals need to fix one by one and taking time. Any one can guide me to quick method?
Anonymous
Never change the column headers in column headers , it will cause inconsistenacy in the data extraction and you need to fix all, instead you can do changes in Power Query , so that step is recorded and every time when ever you want change of the column just do necessary changes in the applied steps!
2 Replies
- VijayPCommunity Champion
Anonymous
Never change the column headers in column headers , it will cause inconsistenacy in the data extraction and you need to fix all, instead you can do changes in Power Query , so that step is recorded and every time when ever you want change of the column just do necessary changes in the applied steps!
- AnonymousNot applicable
Many Thanks Vijay P Ji.,
As per my work nature, I rely on other person data and making report. But sometime those person add colum, change herder and PBI is very sensitive even capital and small letter changes. So I cant make refresh easily. For this issue how can i solve it.
Thanks