Forum Discussion

pyhchan's avatar
pyhchan
Frequent Visitor
4 years ago
Solved

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

Hi, We have Power BI reports sourcing from SAP Business Warehouse and our on premise Power BI Report Server is Sept 2021 version.  The same report with the same data source works fine when it is con...
Report Server
SAP BW Message server connection failed
  • pyhchan's avatar
    pyhchan
    4 years ago

    Here is the fix:

    In the file: C:\Windows\System32\drivers\etc\services

    Add this line: <sap ms server name>      3600/tcp

Jstachow's avatar
Jstachow
New Member
3 years ago

It looks like the connection string bypasses the message server process completely, only allowing connection to a specific application server. My team would like to maintain a successful connection to through the message server so we can take advantage of the back-end benefits. Is there any Power documentation that lists all the connection options and the various parameters possible for an SAP connector?