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
imenmaiza
Helper II
Helper II

The given key was not present in the dictionary

Hello,

I am having a refresh problem and I need help,

Currently, I am using Power BI Desktop (January 2021), after applying changes, it takes long time then I get the following error:

''The given key was not present in the dictionary''


It does occur after the Windows update, I have done some research and it seems like this is due to the Windows update and I need to install the latest Power BI Desktop version. However, I am publishing the dashboard into the power BI report Server which doesn't have may 2021 version yet.

What is confusing is that I have this error only in one dashboard. Isn't I supposed to have this error in all dashboards?

Please be advised that I am using an Excel file and SQL Server databases in my dashboard.

Thanks a lot for your help,

2 ACCEPTED SOLUTIONS
v-yiruan-msft
Community Support
Community Support

Hi @imenmaiza ,

Please review the content in the following thread, hope that they can help you resolve the problem.

Power BI key errors: Fix them with these detailed solutions

The given key was not present in the dictionary - Brand Pack for Power BI Server

Besides that, please check that there is any table without any column only include measure just as the situation with the following issue thread.

DirectQuery for Power BI datasets and Analysis Services: Error Message

Best Regards

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

View solution in original post

Hello all, 

Thank you for your suggestions. This issue was solved after installing the newest Power BI Version.

View solution in original post

7 REPLIES 7
dsimpsontx
Helper I
Helper I

Holy smoke I think I solved the same error message on my dashboard. So I have a column of numeric values, but I vaguely recall that that column had a value that was crazy high. So I specified that it should be int64 and that resolved to stop the error message. 🙂 I hope my solve applies to yours or at least someone else looking.

dsimpsontx
Helper I
Helper I

Holy smoke I think I solved the same error message on my dashboard. So I have a column of numeric values, but I vaguely recall that that column had a value that was crazy high. So I specified that it should be int64 and that resolved to stop the error message. 🙂 I hope my solve applies to yours or at least someone else looking.

TiwariNeha
Frequent Visitor

Hi All , Kindly try to do refresh preview and see if it works. For me , it worked. Kindly marked it as solution if it works. Thanks.

Hello all, 

Thank you for your suggestions. This issue was solved after installing the newest Power BI Version.

v-yiruan-msft
Community Support
Community Support

Hi @imenmaiza ,

Please review the content in the following thread, hope that they can help you resolve the problem.

Power BI key errors: Fix them with these detailed solutions

The given key was not present in the dictionary - Brand Pack for Power BI Server

Besides that, please check that there is any table without any column only include measure just as the situation with the following issue thread.

DirectQuery for Power BI datasets and Analysis Services: Error Message

Best Regards

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

I also received this same error and noticed one of my measure tables was an empty table created by a query instead of a calculated table. I moved my measures to a new calculated table with a blank column and deleted this empty query from my data model. The load then work without any issues.

amitchandak
Super User
Super User

@imenmaiza , For the power BI report server, You can only use the version that optimized for it. And that is Jan 2021 as of now, which you already have.

Log an issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

 

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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