Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

ninaj

An item with the same key has already been added - since June 2017 update

Submitted by on ‎06-15-2017 06:35 AM

Hi everyone,

 

I've updated to the new version of Power BI for June 2017 (2.47.4766.542) and since then my report isn't working anymore. It's been working fine for months but since this update, it gives me the following error : an item with the same key has already been added. I've searched for a solution and I've tried many things but none of them worked. I've gone back to the previous version of Power BI and the report is working again. The problem seems to be in the data that's coming from an Excel file. 

 

Does anyone have the same issue? 

Thanks,

Nina

Status: Needs Info
See more ideas labeled with:
16 Comments (16 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎06-16-2017 01:41 AM

Hi @ninaj,

 

Are you able to connect to Excel file data when in a new report without opening original .pbix?

 

Please enable the desktop trace, then open the original .pbix file use desktop Jun version, share the trace log with us around the time that the error throws out.

 

Best Regards,
Qiuyun Yu

 

Vicky_Song
Impactful Individual
Impactful Individual
‎06-16-2017 01:43 AM
Status changed to: Needs Info
 
ajrajes
Frequent Visitor
‎06-17-2017 12:55 AM

@ninajI am having the same problem with the June update when I try to refresh the data. The problem  is with my Customer table coming from one of my SQL database. I thinking PBI team is working on it. Let's hope to get a fix soon. Let me know if you find any solutions in the meantime. thanks

lubosbednar
Helper II
Helper II
‎06-18-2017 03:33 AM

I am having the same problem with the June update when I try to refresh the data. I had to revert to May 2017 Power BI desktop installation. It occured in one query, which loads data from Sharepoint folder. Although even others queries load data from sharepoint folder as well. When I tried to remove all query steps to keep only content of folder it didn't help.

pgrandits
Frequent Visitor
‎06-19-2017 09:08 AM

I am also having the same issue since I installed the June update.

ssampat
Regular Visitor
‎06-19-2017 02:00 PM

I am also having the same issue with the June update. Everything was working perfectly well while retrieving data from a SQL table. Had to revert to May update. 

While refreshing the Query in Edit Queries, there is no error. Error is only shown when the query is applied.

 

Thanks

Sumit

Bhartman30
Advocate II
Advocate II
‎06-20-2017 04:55 AM

For what it is worth, I am experiencing the same issue. 

 

Thanks

ajrajes
Frequent Visitor
‎06-20-2017 11:17 AM

Hello, does anyone have May 2017 PBI download file? could you please share it with me as I need to avoid this issue urgently.

thanks

v-qiuyu-msft
Community Support
Community Support
‎06-20-2017 11:40 PM

Hi all,

 

As I'm not able to reproduce the issue in Jun release on my side, please enable desktop trace log, repeat the step until the error throws out, then share trace log files with us.

 

You can download May desktop from here.

 

 

Best Regards,
Qiuyun Yu

JonBaylis
Advocate III
Advocate III
‎06-22-2017 01:36 AM

Hi,

 

There is a newer release that what you state above. I think this has shipped yesterday or overnight.

 

It is 2.47.4766.801.

 

Try that.

 

Thanks,

Jon

Idea Statuses