Forum Discussion

friely47's avatar
friely47
Regular Visitor
2 years ago
Solved

Item has already been added. Key in dictionary: 'NavigatorBase_3803694d-dbc2-442b-aff5-fb75dfd09447'

Have 5 stored tables in SQL. I am trying to connect to a new table in the same area and it keeps throwing up the below error message. I am really struggling to understand why it won't let me connect....
Need Help
  • Alex87's avatar
    Alex87
    2 years ago

    Try removing the problematic data source from Power Query. The problem is identified. You need to remove and recreate the connexion to the datasource. If it is not working, you can start from a fresh Power Bi and add all the other queries and measures.

    If my answer helped, please mark it as the solution . Thanks.

Alex87's avatar
Alex87
Icon for Solution Sage rankSolution Sage
2 years ago

Hello,

 

Ensure that there are no duplicate connections or tables with the same name or identifier in your Power BI model. Sometimes, a previously created connection might not have been deleted properly.

Try removing the problematic data source and then re-adding it

 

friely47's avatar
friely47
Regular Visitor
2 years ago

thank you, unfortunatly the option to delete it is not avaliable (greyed out when I right-click on it in Data Source Settings). The only options avaliable are 'Change Source... Edit Permissions... Clear Permissions... Copy Path to Clipboard...' 

I have tried clearing permissions multiple times and re-entering credentials but to no luck 😞

  • Alex87's avatar
    Alex87
    Icon for Solution Sage rankSolution Sage
    2 years ago

    maybe you can start fresh with a new PBI and see if you still have the same problem?