Forum Discussion
PowerBi Append two table with error message "Expression.Error: The field 'xxx' already exists
Does adding Table.StopFolding(<<table>>) around both tables still result in an error?
I.e.
Table.Combine({Table.StopFolding(<<table>>), Table.StopFolding(<<table>>)})
Also, what version of Power Bi (or Excel) are you using?
The data source is data flow. It actually was acting fine but one day the dataset for the report refresh failed and has the error. If I removed the columns throw out the erros, it will just show the next column giving the errors
Does adding Table.StopFolding(<<table>>) around both tables still result in an error?
I.e.
Table.Combine({Table.StopFolding(<<table>>), Table.StopFolding(<<table>>)})
Also, what version of Power Bi (or Excel) are you using?
Hi artemus,
I've stumbled across this while trying to solve this very issue.
I was doing a very simple Table.Combine() with two Dataflows and it was throwing an error that made no sense.
Can you explain this solution and what has changed to cause this to be needed?
Do I need to go and check other Datasets that have this Table.Combine() logic?
Thanks.
If this works it indicates there is a bug in the datasource folding implementation (or less likely the power query engine). This funcation forcable breaks folding and as a result works around the bug.
It did work.
The Datasource is Dataflows using the PowerPlatform.Dataflows() connector in my case.
I wasted 3 hours thinking I was doing something wrong, so was glad to find this post.
Would love to know what has changed and whether this will potentially break existing Datasets.
Yes, it works !! :). I have Version: 2.114.864.0 64-bit (February 2023).
