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
erming's avatar
erming
New Member
6 years ago

You need open/whitelist for IP traffic from Power BI server to your data source.
Test my Power Query Editor code. Upload it to your workspace and update the data. Now you get the PBI server's ip address..

let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://ifconfig.co/ip"))}),
    #"IP-address" = Table.RenameColumns(Source,{{"Column1", "IP address"}})
in
    #"IP-address"


Best Regards,
/Raymond Erming/

  • pade's avatar
    pade
    Advocate III
    5 years ago

    Greate erming 

    But do you have any information about the consistancy of this IP adress. I.E. will it change over time, workspaces or platforms (Shared versus premium instances)?