Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
declanR
Frequent Visitor

Data refresh error. October 2020 last version

Hi!

Com error: mscorlib, An item withe the same key has already been added. Power BI Desktop and PowerBi report server last version.

Source - sql server request. Merging with a table based on a query gives this error on PowerBI Report Server

11 REPLIES 11
declanR
Frequent Visitor

Thanks, MS. My big pain is resolved (maybe). Testing now

Power BI Report Server

  • Version: 1.9.7675.15620 (Build 15.0.1104.300), Released: January 8, 2021
    • Bug fixes
      • Fixed issue with refresh of reports with two or more datasources that differ only by the casing of the letters.
      • Fixed issue with refresh of reports certain combinations of nested joins.
Icey
Community Support
Community Support

Hi @declanR ,

 

Does the latest version solve the issue you encountered?

 

 

Best Regards,

Icey

Icey
Community Support
Community Support

Hi @declanR ,

 

The latest version has been released. Version: 1.9.7675.15620 (Build 15.0.1104.300), Released: January 8, 2021*

It fixed some bugs:

        - Fixed issue with refresh of reports with two or more data sources that differ only by the casing of the letters.
        - Fixed issue with refresh of reports certain combinations of nested joins.

 

Please update and check if it solves the issue you are experiencing.😊

 

Reference: Power BI Report Server October 2020 update 2 - Microsoft Power BI Community

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

declanR
Frequent Visitor

Hi Jean. This is the first thing I tried. Unfortunately, not working for me.

JeanMartinL
Advocate II
Advocate II

I'm also encountering this same error in one of my report.

 

However in my research I've seen that it could potentially be caused by having 2 columns with the same name, which would be the case in your "table 6" (both user_id and week). You could try renaming both of them in the query and see if it fixes the issue.

 

If it ends up being the solution it's a real problem that Desktop and Report Server do not have the same behavior.

Unfortunely, the solution doesn't work. Replase query "table 6" with simple query:

SELECT user_id as user1 FROM user_barcode. The error is the same. 

Hello DeclanR,

 

I managed to find a solution for my issue, I'm not sure if it will work for you but it's worth a try.

 

In short, our datasources were created with different methods (1 line vs 2 lines) even thought they connected to the same DB and when we merged them we would get this error. See this thread for a more detailed explanation: https://community.powerbi.com/t5/Report-Server/COM-error-mscorlib-An-item-with-the-same-key-has-alre...

 

declanR
Frequent Visitor

table 6 - sql request:

SELECT
*
FROM (SELECT
ub1.user_id,
MAX(ub1.timestamp) AS max_timestamp_b,
ub1.week
FROM (SELECT
ub.user_id,
ub.timestamp,
DATEPART(WEEK, ub.timestamp) AS week
FROM user_barcode ub
WHERE ub.timestamp >= '2020-07-27') AS ub1
LEFT JOIN users u
ON user_id = u.id
WHERE u.regdate >= '2014-01-01'
AND u.is_active = 1
GROUP BY ub1.user_id,
ub1.week) AS ub2

declanR
Frequent Visitor

table 3 - sql request:

 

SELECT
ul.user_id,
ul.timestamp AS timestamp_st,
ul.value_new
FROM user_log_data ul
LEFT JOIN users u
ON ul.user_id = u.id
WHERE ul.field = 'level'
AND u.regdate >= '2014-01-01'
AND ul.timestamp >= '2020-07-27 14:30:30.0000000'
AND u.is_active = 1

declanR
Frequent Visitor

2.PNG3.PNG

declanR
Frequent Visitor

1.PNG

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.