Power bi service incremental refresh report data source connection failing intermittently

Hi balajiratnala6,

Based on the error messages provided, it appears that there is an issue with the data source connection or the credentials being used to connect to the data source. Here are some steps you can take to troubleshoot the issue:

1. Check the data source connection: Verify that the data source is accessible and that the connection string used to connect to the data source is correct. You can test the connection by connecting to the data source from the computer where the Power BI Gateway is installed.

2. Check the data source credentials: Verify that the credentials used to connect to the data source are valid and have not expired. If the credentials have expired, update them and test the connection again.

3. Check the Power BI Gateway logs: Review the logs to identify any specific errors or issues that may be causing the connection to fail. The error messages you provided suggest that there may be an issue with the Mashup engine or a cancellation of the command. You may need to consult with a technical expert to help you troubleshoot these issues.

4. Check for updates: Ensure that you are running the latest version of Power BI Gateway, as updates may include bug fixes and improvements that can help resolve connection issues.

5. Review network connectivity: Verify that there are no network issues that could be impacting the connection between the Power BI Gateway and the data source.

If none of these steps resolve the issue, you may need to reach out to Microsoft Support for further assistance.

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly