Forum Discussion
Microsoft SQL : The column 'Name' was specified multiple times for '_'.
Hi Community, In my Power Query, I have a strange error after filtering a column on a value. The error message is : "Microsoft SQL : The column 'Name' was specified multiple times for '_'" ...
I just got this error when Appending two tables together where the columns had the same name but in different case. One was all Caps and the other was mixed case: CUSTOMER and Customer. The crazy part is that the query looks fine in the editor. You get the error on refresh.