Refresh error in powerbi service

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