Gateway connections scheduler

[EricoVincentciu]

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

[lbendlin]

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.

[EricoVincentciu]

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 

[lbendlin]

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.

[EricoVincentciu]

what do you mean about tnc ??

and i think is it not about firewall cause the firewall can't block by anything

[lbendlin]

tnc is a Powershell command "Test network connection" that checks both IP and port connectivity.

[EricoVincentciu]

this is sucsess i think 

[lbendlin]

Good. Next validate that the credentials are correct.

[EricoVincentciu]

how to validate the credentials ??

in fabric ??

like this : 

the error message still same like this : 

[lbendlin · Accepted solution]

Validate them in the SAP BW client.

[EricoVincentciu]

This case already solve, thankyou for your support

[EricoVincentciu]

what is the T-code to validate SAP BW client ??

[EricoVincentciu]

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