Forum Discussion
Scheduled Refresh Fails in Power BI Service After Gateway Update (SAP Data Source)
Hello,
I am experiencing an issue with Power BI Service where the scheduled refresh fails, even though the refresh works normally in Power BI Desktop.
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
Initial Troubleshooting Performed
- SAP GUI login works normally → This rules out incorrect SAP username/password.
- Another VM with an older version of the Gateway can refresh successfully → This suggests the issue is not firewall-related.
Question
Given the symptoms above, what other factors could cause scheduled refresh to fail in Power BI Service after a Gateway update?
Any suggestions or diagnostic steps would be greatly appreciated. Thank you!
------------------------------
GateWay information::
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:
- Re-enter credentials in Power BI Service
- Recreate SAP data source in gateway
- Rebind dataset.
- Check gateway logs.
- 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
4 Replies
- pankajnamekar25
Super User
Hello LIZQQ
try these
Reinstall SAP NCo (64-bit) → version mismatch after gateway update
Check Gateway Service Account → ensure it has SAP access
Re-enter credentials in Power BI Service
Restore SAP Logon config (saplogon.ini / XML path)
Restart or reinstall Gateway
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedIn 
Murtaza_GhafoorPROBLEM 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:
- Re-enter credentials in Power BI Service
- Recreate SAP data source in gateway
- Rebind dataset.
- Check gateway logs.
- 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
v-prasareCommunity Support
Hi LIZQQ ,
if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Murtaza_Ghafoor& pankajnamekar25, Thanks for your prompt response.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support- v-prasare
Hi @LIZQQ ,
if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
