Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

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

 

EricoVincentciu_1-1715152280800.png

 

current date in my zone is (8/5/2024)

 

2. this is my power bi desktop 

 

EricoVincentciu_12-1715154386934.png

 

 

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)

 

EricoVincentciu_3-1715152686664.png

 

4. i can make scheduler and my scheduler sucsess 

 

EricoVincentciu_4-1715152831488.png

 

5. but my data table in power bi app like this 

 

EricoVincentciu_5-1715152998599.png

 

is it not correct, cause i wanna make it balance with my power bi desktop

 

6. when i use On-premises data gateway (Basic)

 

EricoVincentciu_6-1715153245992.png

 

i can't refresh my data schaduler

 

7. i choose skip test connection when i create configuration 

 

EricoVincentciu_7-1715153560450.png

 

8. when i un-check Skip test connection i got this message

 

EricoVincentciu_9-1715153826208.png

 

9. when i ping my connection, my ip server sucsess

 

EricoVincentciu_11-1715154126547.png

 

 

1 ACCEPTED SOLUTION

Validate them in the SAP BW client.

View solution in original post

12 REPLIES 12
lbendlin
Super User
Super User

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 

 

cekkk.png

 

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.

what do you mean about tnc ??

 

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

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

EricoVincentciu_1-1715656166535.png

 

this is sucsess i think 

Good. Next validate that the credentials are correct.

how to validate the credentials ??

in fabric ??

like this : 

EricoVincentciu_0-1715678858015.png

 

the error message still same like this : 

 

EricoVincentciu_1-1715678925676.png

 

Validate them in the SAP BW client.

This case already solve, thankyou for your support

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

i already set up properly my sql server can connect properly but my sap bw can't connect 

 

cekkk.png

 

this is my sap bw error notification 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors