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 ensur...
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/116592
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.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.