Forum Discussion
Enterprise Gateway to on-premise SQL Server
->> "You've still got to click "refresh" within the browser or manually click the report link, but the dataset and/or report will always be updated with the latest data from SQL Server."
1. How does this data refresh happen? Does a message get sent from powerBI.com to the Enterprise Gateway that, in turn, contacts the SQL Server to retrieve the data?
2. If so, what is the mechanism by which the Enterprise GW is contacted by PowerBI.com?
3. Does the GW need to be accessible to the Internet so that the PowerBi.com can make requests to it?
Sorry for the confusion... thanks for any assitance
Thank you
Mike
Hi Mike,
As far as I understand there is only outbound traffic between the on prem gateway and the Azure Service Bus... IT services don't need to open inbound ports on firewalls or something like.
What the gateway does is polls the ASB for any pending requests and if there are some, it goes and fetches the new resultsets delivering it back to the ASB.
Hope it was clear enough.
The only thing that I still don't have clear is how the poll mechanism works... like frequency and stuff like that.