Refresh error in powerbi service

[Alan_0605]

Is there anyone who can help me to handle refresh error in powerbi service?

I tried to publish the powerbi file to the workplace in powerbi service but there is always a error when I refresh the data. The powerbi file can refresh well when it is in the powerbi desktop. The data sources are 3 SAP BW and 2 excel files from sharepoint folder. When we extract data from only 1 BW and 1 month, the refresh succeed, but when we tried to get more data from all BWs and more months, it will show the error again.

We assume it may due to the memory issue so we tried to change the way of extracting data, from directly extracting all data from all BWs simultaneously to extract first one dimension, then the rest of the data using the custom function created with existing dimension, and create a parameter called line number for controlling row numbers of data. The result doesn't change much, when we tried to load small amount of data, it works, but when we tried to load more, it failed.

The error codes are always the same and is listed as follows:

{"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 given credential is missing a required property. Data source kind: SapBusinessWarehouse. Authentication kind: Windows. Property name: SNCPartnerName"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: ALL_Table.

[Anonymous · Accepted solution]

Hi, @Alan_0605 

Based on the error code "DM_GWPipeline_Gateway_MashupDataAccessError" and the message showing that "SNCPartnerName" is missing, there seems to be a problem with the credentials or configuration of your SAP BW data source. You can try the following steps to resolve the problem:

1. Verify the credentials and SNC configuration to ensure that the credentials for the SAP BW data source are entered correctly in the Power BI service. The error message indicates that the "SNCPartnerName" attribute is missing, which is required for Windows authentication using SAP BW. Check the SNC (Secure Network Communications) configurations in the SAP BW system and the Power BI gateway to ensure that they match.

Related link: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

2. Optimize the data model and refresh strategy. consider optimizing the data model to reduce the amount of data processed because of the small data sets that are successfully refreshed. Consider implementing an incremental refresh strategy that refreshes only the data that has changed, rather than the entire dataset. This can greatly reduce the load on the refresh process.

Related link: Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

3. Monitor and analyze gateway performance. if you are using an on-premise data gateway. Monitor its performance to ensure that it is meeting your needs.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum