SAP Business Warehouse Message Server data source not supported on Power BI report server?

yashsharma20 Hello!

Connecting to an SAP Business Warehouse Message Server data source on Power BI report server can be challenging at times. Here are a few troubleshooting steps that you can try to resolve the issue:

1. Ensure that the latest SAP Business Warehouse ODBC driver is installed on the Power BI report server. You can download the driver from the SAP website.

2. Check whether the Power BI report server is running the same version of the SAP Business Warehouse Message Server as the one used by the Power BI Desktop application. If not, you may need to upgrade or downgrade the Message Server version to match the Power BI report server.

3. Verify that the necessary ports are open in the network infrastructure to allow communication between the SAP Business Warehouse Message Server and the Power BI report server. You may need to work with your network administrator to confirm that the appropriate ports are open.

4. Try connecting to the SAP Business Warehouse Message Server data source using a different client tool or application, such as Excel or SQL Server Management Studio. If you encounter issues with other client tools, it could indicate a problem with the SAP Business Warehouse Message Server setup.

5. Check whether there are any known issues or limitations when connecting to SAP Business Warehouse Message Server from Power BI report server. You can review the documentation or support resources from both SAP and Microsoft to see if there are any specific configuration requirements or limitations.

If none of the above steps help to resolve the issue, you may want to reach out to your SAP or Microsoft support team for further assistance. They may be able to provide additional insights or solutions to help you connect to the SAP Business Warehouse Message Server data source on Power BI report server.

I hope this helps!