Scheduled Refresh Fails in Power BI Service After Gateway Update (SAP Data Source)

LIZQQ

PROBLEM STATEMENT:

Environment & Data Source

• Data Source: SAP (BW / ECC)
• Location of issue: Local machine (used for testing)
• Trigger of issue: Gateway update

Symptoms

• Power BI Desktop: Refresh works normally
• Power BI Service: Scheduled refresh fails
• Gateway: Updated on this machine before the issue occurred

SUGGESTED SOLUTION:

Even if SAP is connected locally and works locally alright, the service uses stored credentials via the gateway.

Please do the following checks 

• Check:

          Go to Power BI Service → Dataset → Settings → Data source credentials

• Common Issue: Credentials became invalid or reset after gateway update
• Fix: Re-enter credentials and re-bind the dataset to the gateway

Try the refresh again, see if this gets go through.
If no success then try this quick check list.

Quick Fix Checklist

Try these in order:

1. Re-enter credentials in Power BI Service
2. Recreate SAP data source in gateway
3. Rebind dataset.
4. Check gateway logs.
5. Replicate old VM settings in new VM (Sometimes new version do have some restrictions in place)

👍 If this helps, please give kudos. mark as solution, help others