Forum Discussion
PowerBI Service IP range
My dataset gets data from our organization's own SQL server. The organization has a tight security policy and the SQL server that hosts our data only allows connections from a predermined range of IP...
Unfortunately the on premises gateway is not an option. My organization does not want to maintain any server or desktop machines, even the SQL server is managed by a consulting company. At the moment it looks like providing the SQL server admin with the correct IP range for PowerBI Service is my only option to avoid having to constantly update datasets manually by refreshing reports from PowerBI desktop.
Hi there even with DirectQuery you still have to have a On-Premises Gateway for the 2 worlds to connect.
So without the Gateway you will have to manually refresh the reports and update them. There is a product called Power On which could do this for you?
https://poweronbi.com/
So without the Gateway you will have to manually refresh the reports and update them. There is a product called Power On which could do this for you?
https://poweronbi.com/