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: eacc98a0-a592-3edc-0ab5-d6e078d1973b
Request ID: 0c49d4fc-e2a3-485f-b398-dfb1663e7339
Status code: 500
Error Code: DuplicateTableNameException
Batch ID: dd38b00c-863e-49f1-90c4-501855477a00@f3e477ed-a1e0-4b2b-9e62-dfed01ae3efa$2022-12-13T13:48:30.9239809Z@e09f9db4-8900-434b-b106-d475edb6f715
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,
4 Replies
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-f33f73024059Again 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,
Hi tejyam ,
Here is a user who encountered the same problem as you and solved it successfully, this post is for your reference:
DuplicateTableNameException - Microsoft Power BI Community
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello
PowerBI Community ,
I have already tried solution https://community.powerbi.com/t5/Issues/DuplicateTableNameException/idi-p/2831311 in that which tells us to disable enable load option and it seems that the issue mentioned in that was automatically solved or was solved by trying something but that something solution is not mentioned anywhere in that article.
That was the first thing which I referred when I faced it
Please Suggest me the solution which I can solve for this Problem
Thank you
Hello PowerBI Community,
It will not be as an accepted solution and I have already tried the solution and mentioned but it made no changes to current issue ,can you pleaselet me know anything else which can be helpful
