Forum Discussion

Rnaval's avatar
Rnaval
Icon for Post Partisan rankPost Partisan
1 year ago

Adding or Deleting a column in Excel

I'm using an excel file and when I add or delete a column, the change does not automatically appear in Power BI, I get errors when refreshing data. Is there a seamless way to make changes to my excel...
Need Help
MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
1 year ago

The Advanced Properties are on the Home tab of Transform Data in PowerBI. You are probably looking at Excel.

  • Rnaval's avatar
    Rnaval
    Icon for Post Partisan rankPost Partisan
    1 year ago

    Here's the Transform Data window / Home tab, not seeing Advanced Properties...

     

     

    • MNedix's avatar
      MNedix
      Icon for Solution Sage rankSolution Sage
      1 year ago

      Sorry, it was Advanced Editor

       

      • Rnaval's avatar
        Rnaval
        Icon for Post Partisan rankPost Partisan
        1 year ago

        Here's what I see in Advanced Editor...no column value listed there