Forum Discussion

AlessandroBet's avatar
AlessandroBet
Helper V
6 years ago
Solved

Remove column from xls

I'm getting data from xls file and i have created many visuals. Now i have to remove a column from the xls source and refresh the data. This comun is not used anymore indise PBI file Which is the ri...
Need Help
  • zoloturu's avatar
    zoloturu
    6 years ago

    AlessandroBet ,

     

    If this column was not used in any transformation at PowerQuery steps then you don't need to do anything. Possible types of steps which can contain the name of the column in a transformation are Renamed columns, Pivot/Unpivot, Reordered columns, Transpose etc. Actually, you can go to Advanced Editor and remove the name of this column from all steps. 


    Regards,
    Ruslan Zolotukhin (zoloturu)
    BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
    -------------------------------------------------------------------
    Did I answer your question? Mark my post as a solution!
    It was useful? Press Thumbs Up!

    You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

AlessandroBet 

If the columns is not used at all. Simply delete in the excel then manual refresh will not cause any error. 

Best,
Paul