Forum Discussion
Solved
Problem happens when I try to expand a record as a table
Hi All, I'm new to power bi desktop and power query. Now I have a table named ProjectsSummary which contain 5 columns which will be used below: [PN] [StartDate] [MonthsBetween] [MonthlyQty] [Pri...
It looks like the column names are wrong in the last step "Expanded SalesOrder". You can't have names in the embedded table being expanded to names that already exist.
Have you edited this manually because I think if you delete the last step and then expand from the column header, it should create the code automatically and work.
If that doesn't work, please post some sample data and i'll test it
I tried to do the whole work from start again and things worked.
So maybe that's the problem, your column names are not able to be duplicated after expanding.
Thank you for your help sir!