I'm looking for some help with gateways. The PBI scheduled refreshes at my company suddenly stopped working overnight, from what I can tell, the error has something to do with the gateway. Unfortunately, everyone who was involved in setting up the gateway is now gone, so I'm at a loss as to what to do. We use On Premises gateway in personal mode that shows it is online and ready to be used, and we connect to a SQL Server. Also, when I refresh one of the reports in PBI Desktop, it refreshes fine with no issues, and the query editor doesn't show any errors. MS support has not responded to my ticket.
Any advice would be greatly appreciated.
Error:
Something went wrong
There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. 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":"[Schema = \"Erp\", Item = \"ProdGrup\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: dProductGroup. Cluster URIWABI-US-EAST2-redirect.analysis.windows.net Activity ID5c7699b0-7db4-42c7-a780-ac703d915f35 Request IDf6c90b28-4403-4ebe-827e-233ed7a57a89 Time2020-10-16 11:41:46Z
