Forum Discussion
(500): Internal Server Error with SAP B1 Service Layer
- 2 years ago
Solved using the Feed OData connector, and adjusting the end of the URL from v1 to v2.
Try enabling the necessary firewall rules for Power BI to communicate with SAP Business One (SAP B1), follow these steps:
1. Power BI Service Endpoints:
- Power BI relies on specific endpoints for its functionality. Ensure that the following endpoints are reachable from your SAP B1 server:
- api.powerbi.com (TCP Port 443)
- \.analysis.windows.net (TCP Port 443)
- \.pbidedicated.windows.net (TCP Port 443)
- content.powerapps.com (TCP Port 443)
- datamart.fabric.microsoft.com or datamart.pbidedicated.windows.net (TCP Port 1433)
- dc.services.visualstudio.com (TCP Port 443)
- arc.msn.com (TCP Port 443, optional)
- nps.onyx.azure.net (TCP Port 443, optional)
2. Microsoft 365 Authentication and Identity:
- Power BI depends on Microsoft 365 endpoints for authentication. Ensure connectivity to the following:
- Microsoft 365 Common and Office Online URLs (N/A)
3. Portal Access:
- For general use of Power BI, allow access to:
- \.powerbi.com (TCP Port 443)
4. Gateway Administration (Preview):
- If you're using gateway administration features, allow access to:
- gatewayadminportal.azure.com (TCP Port 443)
5. Service Telemetry:
- To monitor service telemetry, allow access to:
- dc.services.visualstudio.com (TCP Port 443)
6. Additional Optional Endpoints:
- Consider allowing access to optional endpoints for informational messages and NPS surveys.