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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
skorejo
Regular Visitor

Microsoft.Mashup.Evaluator.Interface.exception: The given key was not present in the dictionary.

I am getting the following error on Power BI and it seems not to be working at all with any query (with simple query like select * from sometable too ). I also tried to reinstall Power BI , removed cache but it was of no use . Kindly help.
 
--------------------------------------------------
Please provide a complete description above.
 
Data to send to Microsoft:
 
 
Feedback Type:
Frown (Error)
 
Timestamp:
2018-02-20T11:10:33.0120840Z
 
Local Time:
2018-02-20T16:10:33.0120840+05:00
 
Session ID:
0b96de79-a7c0-4676-9f31-9224d6b90633
 
Release:
January 2018
 
Product Version:
2.54.4970.961 (PBIDesktop) (x64)
 
Error Message:
The given key was not present in the dictionary.
 
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.<>c.<.cctor>b__2_13(MySqlConnectionStringBuilder msb, MySqlConnectionStringOption sender)
   at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.GetConnectionString(Boolean includePass)
   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.PagingEnumerator.TryGetPage(Int64 offset, Int32 count, IEnumerator`1& page)
   at Microsoft.Mashup.Engine1.Library.Common.DbValueBuilder.PagingEnumerator.MoveNext()
   at Microsoft.Mashup.Engine1.Runtime.SkipTakeEnumerator`1.MoveNext()
   at Microsoft.Mashup
5 REPLIES 5
v-yuezhe-msft
Employee
Employee

@skorejo,

I am unable to reproduce this issue in the latest version of Power BI Desktop. Could you please install February update of Power BI Desktop and check if the error still occurs?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia,

 

I have tried to install latest version (the one you sent in link - tried both 32 and 64 bit installers) but I am getting same issue. Seems like even if I uninstall it, there is some file remaining in my file system causing this issue. Although I did try deleting cache too still it did not work.

 

Please suggest the fix for this.

 

Regards,

Skorejo

Were you able to find a solution to this error message?

@skorejo,

I would recommend you open a support ticket on the support.powerbi.com site.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

How is a ticket opened on the site?  I can not find any way to open a ticket and this issue presented immediately after updating windows today.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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