Forum Discussion

viniciusabreu's avatar
viniciusabreu
Regular Visitor
3 years ago
Solved

Refresh a dataset created from an Excel workbook - Power BI

I imported from a folder and in my most recent file (in the base file of the folder) I need to add a new column. In PowerBI this new column is not showing up. somebody help me?

  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi viniciusabreu 
    Glad to help 🙂  please consider Accepting it as the solution to help the other members find it more quickly

3 Replies

  • Hi viniciusabreu 
    You need to modify some steps in PQ to have this new column :
    1. Go to the "removed other columns" step and check on the "transform file" option:

    2. Excpend this column and select all needed columns from your Excel:

    Edit the next steps according to your needs.
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly








    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User

      Hi viniciusabreu 
      Glad to help 🙂  please consider Accepting it as the solution to help the other members find it more quickly