Fixing visuals

[Anonymous]

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?

[VijayP · Accepted solution]

@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!

[Anonymous]

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