Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

The key didn't match any rows in the table error.

Hello everyone,


I'm encountering an error when I try to set up a daily refresh for a report. The report accesses a table from the cloud and a table from an on-prem server. The tables are connected via a relationship in the model, there is no merging or appending. When I refresh my report in the desktop, there is no issue but refreshing in the service returns this error: 


The table mentioned in the error is the one found in the cloud. The only manipulation of the columns I have done is that I duplicated a timestamp column that Power BI sees as a text column (so that I didn't change anything in the original column) and manipulated the duplicated column to take out extraneous strings and convert to date time instead of text.  


I did some research and some suggested it's because a column or tables name has changed. I reloaded the table into the report and didn't change any of the column names and reuploaded to the service to still get this error. 


Any help would be appreciated. Thank you.


Edit: I completely removed the table that connects to the on-prem server and I'm still getting this error. 

Impactful Individual
Impactful Individual

Hi @Neka,

Do you have installed an on-premises data gateway? 

Hope it helps.



Yes, we use that data gateway all the time with no issues. 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors