Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Dataflow
GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

If you are using the Power BI On-Premise Gateway this will complete the refreshing for you.

All that you would need to provide is the IP Address of the server where you have got the On-Premise Gateway installed. This is what will be used to connect to the SQL Server.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

    • GilbertQ's avatar
      GilbertQ
      Super User
      6 years ago
      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/