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

 

juleshorton's avatar
juleshorton
Icon for Advocate III rankAdvocate III
1 year ago

This error appears as soon as I select "Enter Data" to add an excel sheet as a static table. There is no duplicate data source because I don't get that far. I can't use the "Enter Data" option at all.