Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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!
Proud to be a Super User!
@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!
Proud to be a Super User!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |