how to refresh report after publishing, database is connected through vpn on my local laptop

[ven666]

i used power bi to generate report which connects to the db, which needs openvpn on my local laptop. now i published the report and try to refresh it, but it's not working due to it needs openvpn to connect to db. the database server is on linux ec2 machine, and gateway can't be installed there. is there any way to refresh the report after publishing and how to avoid the vpn issue? 

[lbendlin]

No. Power BI has no idea what a VPN is or how to operate it.

[ven666]

is there a way to get PowerBI server CIDR?

[lbendlin]

Please explain what you mean by "Power BI Server".  Do you mean the Power BI Service in Azure, Or Power BI Report Server on-premise?

[ven666]

The semantic model I published after finishing with powerBI desktop

[lbendlin]

That semantic model resides in the Azure cloud. far away from any VPNs

[ven666]

 is there any way to refresh the report after publishing?

[lbendlin]

If the semantic model has a scheduled refresh set up then every time you publish from the Power BI Desktop to the workspace that will initiate an ad-hoc refresh.    

[ven666]

so now we have a postgresql db in ec2 linux machine, and we want to auto refresh the powerBI report after publising. is there any way to get this work?

[lbendlin]

If the semantic model has a scheduled refresh set up then every time you MANUALLY publish from the Power BI Desktop to the workspace that will initiate an AUTOMATIC-ish ad-hoc refresh.    

[ven666]

we don't want to have any manual process. so manually publish won't be an option.

[lbendlin]

Based on your setup it's your only option.