Forum Discussion
new column in Excel source data gives error
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
2 Replies
- 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/116592Assuming 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-queryBest Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 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/116592Appreciate 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
