I have three similar 'Customer Facing' PowerBI reports (in Tenant A) each of which, takes data from a database (in Tenant B) through an installation of Microsoft Data Gateway (in Tenant B) that has an ODBC connection to the database, I am getting the following errors from the there reports, when trying to refresh the data. Each of the reports references around six tables/views, returning a total of 2 million rows of data. These same reports hav previously been working and we are not aware of any changes that would have impacted the data refresh.
I have just created a very simple PowerBI report which looks at a small table (3 columns, 20 rows) in the same location and that refreshes without any issue. When I open one of the troublesome PowerBI reports in PowerBI desktop on my PC (which is connected to Tenant B) it uses a duplicate of the ODBC connection, which is local on my PC - data refreshes without issue. We also have 'Emloyee Facing' reports (in Tenant B), which use the same Microsoft Data Gateway (in Tenant B) and these are refreshing without any issue.
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":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: REDACTED TABLE NAME.
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":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: REDACTED VIEW NAME.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_OutOfMemoryError","pbi.error":{"code":"DM_GWPipeline_Gateway_OutOfMemoryError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: REDACTED TABLE NAME.
I am keen to understand the error and the possible causes/solutions, but also curious why one report gives a different error to the other two.
