Error When Refreshing Dataset From Dataflows

[Anonymous]

Hi,

I have a dataset that pulls in data from dataflows, and some sharepoint lists. It refreshes fine when I refresh from desktop, but in the service i get this 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":"[workspaceId = \"f046bb83-939b-4a9d-bab7-4499118a66ff\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"workspaceId\", \"workspaceType\", \"Data\", \"workspaceName\", \"Tags\", \"ItemKind\", \"ItemName\", \"IsLeaf\"}, {})"}}],"exceptionCulprit":1}}} Table: TUER_ABSENCE_V: Absence Detail.

The refrenced table is from the dataflow, but it changes each time. Most of the dataflows are pretty much just pulling data from an Oracle database, and there isnt a lot of manipulation within them.

Anyone have any idea what could be causing this error?

[GilbertQ]

I am not exactly sure why, I would try and see if the code is different in the Power BI Service?

[GilbertQ]

Hi @Anonymous 

The error says that it is missing Key's

Could you be joining data using Keys and for some reason when the dataset is refreshed they are not there?

[Anonymous]

Thanks for your reply. How would it be possible that the keys would be missing when refreshing in service, but not when refreshing in desktop?