Power BI key errors: Fix them with these detailed solutions

by Tashreef Shareef
Tashreef Shareef
Tashreef Shareef
Windows & Software Expert
Tashreef Shareef is a software developer turned tech writer. He discovered his interest in technology after reading a tech magazine accidentally. Now he writes about everything tech from... read more
Affiliate Disclosure
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

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

Fix power bi key errors
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.
    Fix power bi key errors
  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

Fix power bi key errors
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.Fix power bi key errors
  3. Download and install if any update is available for the Power BI App.

Upload the files in a Zip File

Fix power bi key errors

  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

Fix power bi key errors
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.


Still having issues? Fix them with this tool:


If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: