Power BI key errors: Fix them with these detailed solutions

Power BI key errors can occur in different ways with a different error message. Some of the Power BI error key messages reported by the Power BI users include Power BI error the given key was not present in the dictionary, power bi error the key didn’t match any rows, and power bi error generating an asymmetric key.

Follow the troubleshooting steps for each error below to resolve Power BI key error.

How to fix various Power BI key errors

1. Power BI error generating an asymmetric key

Change the Virtual Machine 

1. If you are using a Virtual Machine and getting the Power BI error generating an asymmetric key, try to install the gateway in a different Virtual Machine.
2. Users have reported that installing the Gateway on a different virtual machine has resolved the error.

Upgrade the OS (Windows Server)

1. If you are installing the Gateway on an older version like the 2008 Windows Server, try upgrading to the newer version Windows Server 2012 or later.
2. Due to incompatibility issues or other glitches, the gateway installation may fail in the older version of Windows Server 2012.
3. Simply install the Windows Server on a virtual machine and try to install the gateway.
4. Check if the generating an asymmetric key error is resolved.

Install Data Gateway Manually 

1. In case the issue is at the Power BI end, you can try to install each gateway manually.
2. To install the On-Premises data gateway, go to Install On-Premises.
3. To install the On-premises data gateway (Personal Mode) go to Install On-Premises (Personal Mode) link.
4. Download and install the data gateways manually and check if the error is resolved.

Change Logon User for Service

1. If you haven’t already, try changing the logon user for Service.
2. Press Windows Key + R to open Run.
3. Type services.msc and click OK.
   
4. In the Services window, locate and double-click on Power BI Gateway – Enterprise Service.
5. In the Logon tab, select the “Local System Account” option.
6. Click Apply and OK to save the changes.
7. Now try to install the gateway and check if the error is resolved.

Did you know how to refresh data in Power BI? Learn how by following these guides.

2. Fix Power BI error the given key was not present in the dictionary

Update the Power BI App

1. If the issue is occurring after installing Windows update, then Microsoft will most likely release an update to fix the issue.
2. Launch the Microsoft Store app and look for the Power BI.
3. Download and install if any update is available for the Power BI App.

Upload the files in a Zip File

1. To upload a brand pack with multiple files it is important that you zip the folder containing the files and then upload it.
2. So include the Metadata.xml, logo.png and color.json file in a folder.
3. Now compress the folder using free compressing software.
4. Upload the compressed file to the Branding section.

3. Fix Power BI error the key didn’t match any rows

Revert the Changes Made to Table in Database

1. If you have recently made any changes to any table in the database and getting this error, then try to revert the changes to resolve the error.
2. Click Home and select Edit Queries.
3. Under Applied Steps, remove the navigation.
4. Click Close and Apply.
5. Now try to access the table in the database and check if the error is resolved.

RELATED STORIES YOU MAY LIKE:

• How to refresh data in Power BI [STEP-BY-STEP GUIDE]
• 5 free cloud accounting software to keep your books updated on the fly
• Top 3 browsers for seamless SharePoint use