Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone, we are experimenting some issues when trying to load our information in Power BI Service to our Reports which use SAP Business Warehouse as Data Source.
Background:
This report has been published in PBI Service for almost 3 months, but eventually we had to make some adjustments and had to add information from WEB data source. With this last adjustment, our .pbix file increased it size from 20Mb to 200Mb. Nevertheless, this report always takes 30-40mins to upload in Desktop and 25-30mins to upload in PBI Service. Nevertheless, today we had an issue refreshing the data on PowerBI Service even though we are not presenting any issue refreshing the data from PBI Desktop. The error that appears is the following:
Ha habido un error
Se ha producido un error al procesar los datos en el conjunto de datos.
Vuelva a intentarlo mas tarde o pôngase en contacto con el soporte técnico. Proporcione estos detalles si se pone en contacto con ellos.
Error del origen de datos {"error":{"code":DM_GWPipeline_Gateway_MashupDataAccessError","pbbi.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: DATA TAREAS.
URI de cluster WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Hora 2020-06-04 19:48:27Z
Cerrar
My questions are:
Thank you..
Hi @Anonymous ,
Whether the report can refresh successfully in Power BI Desktop after made adjustments? According to that error log, table DATA TAREAS is mentioned. Which transformations have been made to this table? How many rows in this table?
Please upgrade the gateway to the latest version, and keep only one type of gateway running on a machine (either an enterprise gateway or a personal gateway). Do not run both type of gateways at the same time.
Best Regards
Rena