new column in Excel source data gives error

[MarcUrdang]

Good morning 

When I add a new column into my Excel data source and then refresh PBI I receive an error message that says that the particular column was not found. 

What do I have to do to ensure that PBI reads the new column?

thanks

Marc

[V-lianl-msft]

Hi @MarcUrdang ,

You can refer to this:https://community.powerbi.com/t5/Desktop/Add-a-new-column-to-the-existing-data-set-and-refresh/td-p/... 

Assuming the structure of the table didn't change ,you can append the table with data to the existing table wih data in edit queries:http://radacad.com/append-vs-merge-in-power-bi-and-power-query 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer

https://community.powerbi.com/t5/Desktop/Add-an-extra-column-from-excel-source/td-p/324604
https://community.powerbi.com/t5/Desktop/Add-a-new-column-to-the-existing-data-set-and-refresh/td-p/...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin