Forum Discussion
New column in excel
Hello,
I have add a new column in my excel files that is linked to my power bi. But I can't add the data that are is this new column in my excel in power bi... I even didn't see the column when i want to transform the data in power bi... Can someone help me ?
Thank you !
Hello Manonf ,
maybe you've used choose columns in power query to select specific column which will eleminates any other columns that aren't the selected ones.
Oh yes that was it ! Thank you !
6 Replies
- audreygerred
Super User
Hello - did you do a manual refresh in Power BI desktop or did you just refresh in Service?
I've done a manual refresh in power bi desktop
- audreygerred
Can you check Power Query to make sure none of your steps are specifying which columns to include and then do a refresh preview.
- PijushRoy
Community Champion
Hi Manonf
What is the location of the excel file, in your local PC or Azure Blob storage or other location?
Please check your Power Query steps, if you are using any Select Column or Delete Column Steps.
Please confirm
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin - Idrissshatila
Hello Manonf ,
maybe you've used choose columns in power query to select specific column which will eleminates any other columns that aren't the selected ones.
Oh yes that was it ! Thank you !
