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

[Neka]

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. 

[calerof]

Hi @Neka,

Do you have installed an on-premises data gateway?

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install 

Hope it helps.

Cheers,

Fernando

[Neka]

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