Forum Discussion
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?
Hi viniciusabreu
Glad to help 🙂 please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
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 - viniciusabreuRegular Visitor
you are incredible. It worked, thank you very much!!!!
- Ritaf1983
Super User
Hi viniciusabreu
Glad to help 🙂 please consider Accepting it as the solution to help the other members find it more quickly