Forum Discussion
Gateway connections scheduler
i wanna ask about my question,
currently i wanna make scheduler base on my data source on my power bi desktop, and i wanna make from my power bi app balance with my desktop
can some one help me how to do that ??
1. this is my power bi app
current date in my zone is (8/5/2024)
2. this is my power bi desktop
base on data source, table at power bi app must be same with table on power bi desktop
3. when i use On-premises data gateway (personal mode)
4. i can make scheduler and my scheduler sucsess
5. but my data table in power bi app like this
is it not correct, cause i wanna make it balance with my power bi desktop
6. when i use On-premises data gateway (Basic)
i can't refresh my data schaduler
7. i choose skip test connection when i create configuration
8. when i un-check Skip test connection i got this message
9. when i ping my connection, my ip server sucsess
Validate them in the SAP BW client.
13 Replies
Doesn't look like your gateway is setup correctly. Remember that ping is note enough either, you need to tnc against the port.
Until you can fix your gateway you should continue to refresh in the Power BI Desktop and publish to the service.
i already set up properly my sql server can connect properly but my sap bw can't connect
this is my sap bw error notification
i already set up properly my sql server can connect properly but my sap bw can't connect
this is my sap bw error notification
Remember that ping is not enough, you need to tnc against the port. Work with your IT team to request the port be opened in the firewall.
Hi EricoVincentciu,
For the native SAP BW connection, a successful ping is not enough. The gateway machine must reach the correct SAP host and port, have the required SAP .NET Connector installed, and use valid credentials for the correct SAP client.
If the required data is available through SAP OData services, you may also consider Power BI Connector for SAP:
For on-premises SAP, it uses SAP Cloud Connector and a BTP Destination and provides an OData endpoint that supports scheduled refresh. It would not fix the existing SAP BW gateway connection or connect directly to BEx queries.
A 30-day free trial is available.
Documentation:
https://metricasoftware.com/docs/sap/Cheers,
Metrica Team
