Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

  • VijayP's avatar
    VijayP
    Community 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!

    • Anonymous's avatar
      Anonymous
      Not 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