Datamart-DuplicateTableNameException

[tejyam]

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,

[v-yadongf-msft]

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.

[tejyam]

Hello PowerBI Community, 

@v-yadongf-msft ,

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

[tejyam]

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

PREVIEW

[tejyam]

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,