SharePoint Online firewall port

Question

Hi all,&nbsp;Due to certain limitation, I will need to work on the Power BI Desktop solution in our server. As usual, our server has all the hardening configuration in place except for connection to our DW database server.&nbsp;I am currently working on a solution with Excel files hosted in SharePoint Online folder. I could not refresh the whole data model as our server could not reach SharePoint Online from within the server.&nbsp;&nbsp;Do anyone know what ports should I inform infra team to open for SharePoint Online folder?&nbsp;Thanks.

amitchandak · Answer

maximus85 , refer if these can help
&nbsp;
https://docs.microsoft.com/en-us/microsoft-365/enterprise/urls-and-ip-address-ranges?view=o365-worldwide
&nbsp;
https://docs.microsoft.com/en-us/sharepoint/security-for-sharepoint-server/security-hardening
https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls

maximus85 · Answer

Hi amitchandak,I have checked the link provided by you and seems like this link has the information I needed:&nbsp;https://docs.microsoft.com/en-us/microsoft-365/enterprise/urls-and-ip-address-ranges?view=o365-worldwide#sharepoint-online-and-onedrive-for-business&nbsp;Do the infra needs to allow for both the Addresses and Port? Which category should they focus on?Thanks.&nbsp;

Forum Discussion

SharePoint Online firewall port

2 Replies

Related content

OData Error When Connecting to SharePoint Online

Sharepoint online and Reporting server

Azure SQL Firewall

SharePoint Online List in Dataflow Gen2

Query Firewall Violation