Forum Discussion
Alias table creates duplicate columns
Never mind qualifying tables and column names correctly in the queries resolved this. SQL Server does not interpret the queries the same way.
Anonymous provide more details. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
TableA & TableA1 are the same table. The table has around 50 columns.
By requirement we had to alias this. The Dataset has a select * from TableA where TABLEA.COLUMN5 ='xyz' as the query.
Do not understand why certain columns have been duplicated all of a sudden. These duplicates were not present when we deployed the model.
One difference I noticed is that CREATEDBY column in the Table populated new user values over the last run instead of our standard SSIS user.
Anonymous I'm not sure what you mean by duplicate columns, please explain in detail.
DUPLICATE COLUMN- Same column appears twice in a table as COLUMNNAME & COLUMNNAME1
After looking at closely I see that TABLEA.COLUMN3 has a similar name to TABLEB.COLUMN4 and TABLEA now shows both COLUMN3 & COLUMN4 as COLUMNNAME & COLUMNNAME2.
Anonymous I have no single clue about your question, I'm going to request to read this post again. Hope someone else can help
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490