cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kh0050
Frequent Visitor

Dataset Refresh - Issue

My laptop lock screen has shut down the VPN and the VPN has shut down the Power BI gateway which stopped refreshing the dataset from the oracle database. I cannot change my lock screen settings because of our institute data protection policy. Any suggestions, please?

 

Thanks

1 ACCEPTED SOLUTION
negi007
Super User II
Super User II

@kh0050 i guess you are using On-premises data gateway (personal mode), in that case you will need to have your personal computer where personal gateway installed to be on all the time. Also, VPN should also be available else data will not get refershed. I have faced similar issue accessing AWS DB from my local computer. 

 

I would recommend using On-premises data gateway (standard mode) to overcome this problem, 

https://powerbi.microsoft.com/en-us/gateway/

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-faq

 

negi007_0-1622634733428.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

2 REPLIES 2
negi007
Super User II
Super User II

@kh0050 i guess you are using On-premises data gateway (personal mode), in that case you will need to have your personal computer where personal gateway installed to be on all the time. Also, VPN should also be available else data will not get refershed. I have faced similar issue accessing AWS DB from my local computer. 

 

I would recommend using On-premises data gateway (standard mode) to overcome this problem, 

https://powerbi.microsoft.com/en-us/gateway/

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-faq

 

negi007_0-1622634733428.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

amitchandak
Super User IV
Super User IV

@kh0050 , Ideally power bi Gateway should be on a separate machine that should always be on.

Better install it on always-on machine

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors