New column in excel

[Manonf]

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 !

[Idrissshatila · Accepted solution]

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.

[Idrissshatila · Accepted solution]

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.

[Manonf · Accepted solution]

Oh yes that was it ! Thank you !

[PijushRoy]

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

[audreygerred]

Hello - did you do a manual refresh in Power BI desktop or did you just refresh in Service?

[Manonf]

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.