Home

Get Office 365 IP and URLs using Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-1070979%22%20slang%3D%22en-US%22%3EGet%20Office%20365%20IP%20and%20URLs%20using%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1070979%22%20slang%3D%22en-US%22%3E%3CP%3ESometime%20ago%2C%20I%20had%20this%20Office%20365%20Migration%20and%20as%20part%20of%20the%20planning%20I%20told%20the%20customer%20about%20allowing%20%2F%20by-passing%20office%20365%20URLs%20and%20IPs.%20The%20customer%20was%20somewhat%20suspicious%20but%20took%20it%20fine.%20Then%20I%20was%20asked%20to%20fill%20a%20form%20where%20I%20should%20manually%20put%20IP%2C%20by%2C%20IP%2C%20endpoint%2C%20by%20endpoint%20all%20information%20regarding%20connections%20on%20Office%20365.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20was%20why%20I%20used%20the%20official%20documentation%20to%20create%20a%20Excel%20%2F%20Power%20BI%20Model%20where%20you%20can%20query%20all%20Office%20365%20URL%20and%20IP%20information%20and%20Im%20glad%20to%20share%20with%20the%20community%20all%20the%20steps%20I%20did%20to%20work%20on%20this.%20You%20can%20find%20my%20blog%20article%20%3CA%20href%3D%22https%3A%2F%2Fbit.ly%2F36KlU11%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eright%20here%3C%2FA%3E%26nbsp%3B(link%20opens%20in%20a%20new%20page).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3C%2FSTRONG%3E%3A%20I%20know%20that%20the%20IP%20addresses%20do%20not%20necessarily%20follows%20the%20URLs%2C%20but%20it%20was%20how%20I%20managed%20to%20fill%20that%20customer's%20form%20so%20we%20could%20keep%20up%20with%20the%20project.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20guys%20have%20any%20questions%2C%20please%20let%20me%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnjoy!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1070979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Network%20Connectivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Sometime ago, I had this Office 365 Migration and as part of the planning I told the customer about allowing / by-passing office 365 URLs and IPs. The customer was somewhat suspicious but took it fine. Then I was asked to fill a form where I should manually put IP, by, IP, endpoint, by endpoint all information regarding connections on Office 365. 

 

This was why I used the official documentation to create a Excel / Power BI Model where you can query all Office 365 URL and IP information and Im glad to share with the community all the steps I did to work on this. You can find my blog article right here (link opens in a new page).

 

Note: I know that the IP addresses do not necessarily follows the URLs, but it was how I managed to fill that customer's form so we could keep up with the project.

 

If you guys have any questions, please let me know.

 

Enjoy!