Data refresh error help needed

[kattlees]

I have a dataset up and running. On the desktop I can click refresh and everything works great. When I publish the dataset and click refresh, I get a Failed message each time similar to below. The gateway has been tested and shows it is good to go. My problem is the table changes each time I try to refresh (1st and 4th lines)

I have removed some letters from the activity ID and request ID

Underlying error code:	-2147467259 Table: Employee Info.
Underlying error message:	The key didn't match any rows in the table.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.Key:	[Schema = "dbo", Item = "Employees"]
Microsoft.Data.Mashup.ValueError.Reason:	Expression.Error
Cluster URI:	WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Activity ID:	e6669d99-5cc2-41ef-......................
Request ID:	caf81b71-4ccd-d05e-.......................
Time:	2019-09-26 13:45:13Z

[v-lili6-msft · Accepted solution]

hi, @kattlees 

You may refer these similar post:

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

https://community.powerbi.com/t5/Service/Key-Expression-Error-The-key-didn-t-match-any-rows-in-the-t...

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

Best Regards,

Lin

[Artie]

Hi Lin,

I do have the same problem.  I tried the referred posts but none of them worked for me.  I did a test by working on a report on the desktop version, adding each table at time and publishing it to the web service. I found out the report is broken when I append an on premise Gateway table to a BI Dataflow table.

I did rebuild the BI Dataflow from scratch as well as the Power Query tables in the desktop version and none of them worked (I did put attention on the data types).

Any clue of what else may be failing?

Thanks.

Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The key didn't match any rows in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[entity = \"fact_Sales\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: fact_Sales.

[kattlees]

Thank you. The 4th link worked. I searched and searched but couldn't find it before posting.