- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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,
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello all,
Thank you for your suggestions. This issue was solved after installing the newest Power BI Version.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello all,
Thank you for your suggestions. This issue was solved after installing the newest Power BI Version.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
Subject | Author | Posted | |
---|---|---|---|
06-27-2021 11:55 PM | |||
01-10-2025 05:07 PM | |||
Anonymous
| 02-02-2023 06:03 AM | ||
06-24-2024 06:17 AM | |||
05-20-2024 07:28 AM |
User | Count |
---|---|
136 | |
107 | |
88 | |
58 | |
46 |