Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good afternoon,
I've used Power BI for a good couple of years now however I don't have a mass of experience in gateways / VPN's, scheduled refreshes etc.
I have reports running with data from SQL server and after installing a personal gateway on my machine and setting up Scheduled-Refresh my reports now refresh themselves accordingly.
The problem I have however is that when my device is not connected to the VPN (I have to use this to connect to SQL server), it's unable to refresh the reports and the scheduled-refresh falls over.
Is there a way for me to have it so I don't need to be on the VPN on my machine for the scheduled refresh to work? I appreciate the issue is security related as I'm unable to access the DB without a VPN, but surely there's a way to have it refresh even when i'm not on my computer?
Any advice would be fantastic, and hope the above makes sense 🙂
Solved! Go to Solution.
Hi @JordanPearson ,
you need a Power BI Data Gateway in your company's IT infrastructure.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
Hi @JordanPearson ,
you need a Power BI Data Gateway in your company's IT infrastructure.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
@JordanPearson as @mwegenersuggested it is not scalable to use the personal gateway as everything will be dependent when your machine is online, is it on the same network (like need VPN) to access the database. To a more scalable and efficient solution, Power BI Gateway should reside on a server like a machine, which is running 24 x 7 and have access to on-prem data sources.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |