Hello everyone,
In our organization we have some reports connected to SAP using Microsoft's SAP BW connector for Power BI (https://docs.microsoft.com/es-es/power-bi/connect-data/desktop-sap-bw-connector). The reports worked fine until last week, when we started to get this error in some of them:
{"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":"SAP Business Warehouse: Time limit exceeded"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Clientes.
At first glance it seems that there is a problem with table "Clientes". We checked the table and it looks OK, there is no problem with the data nor the transformations and the query has not changed in weeks. Three different reports have this same error and they don't share information of any kind (query or anything), the only difference between them is that the error says that the problem is with another table. The data volume hasn't changed drastically in any of them.
The strange thing is that, when we try to refresh the report in Power BI Desktop, it works perfectly. We can refresh and publish everytime and we get the latest data, but when we try to refresh (automatically or manually) in Power BI Web, we get the error.
Is there a time limit difference between Power BI Desktop and Web? Does anyone have any clue of what the error really can be?
Thank you in advance,
Kind regards
