Forum Discussion
Datamart-DuplicateTableNameException
Hello
Powerbi Community,
I tried to create a Datamart with 14 tables which are referencing to same table in SQL server but, while taking in powerbi Datamart we are selecting different columns and naming them differently with respect to tables.
When I created the data mart it was successfully created without any error but when I again opened it in edit query option and tried saving it throws the below error.
Activity ID: 54f39e13-845a-b592-fe1d-62e83d692fa8
Request ID: bd93b2bb-80c0-4c4b-812c-9b3bd4e66629
Status code: 500
Error Code: DuplicateTableNameException
Batch ID: dd38b00c-863e-49f1-90c4-501855477a00@f3e477ed-a1e0-4b2b-9e62-dfed01ae3efa$2022-12-13T14:26:37.8189968Z@e2a9ddb2-2f7a-47ad-9e5b-f33f73024059
Again I opened the data mart and opened Power Query window and changed the table names.when I saved it, it was successful this time but again after opening the power query window to do any changes and trying to save it, it gave the same error.
I researched a bit on google and first of all we have very little available for this but I found an article which stated that disabling the enable load option of tables might solve this but it did not work for me.
Can anyone from your team please help us with as this is something very important for my team and organization?
Do let me know if you need more details from my side on this!
Thanks,