The given key was not present in the dictionary

[imenmaiza]

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,

[v-yiruan-msft · Accepted solution]

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

[dsimpsontx]

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]

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]

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.

[imenmaiza · Accepted solution]

Hello all, 

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

[v-yiruan-msft · Accepted solution]

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

[ahri_eh93]

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]

@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