Power BI - Business Warehouse (BW) Connection

[Anonymous]

Hello everyone,

Right after I succeed at connecting to the SAP BW, the navigation menu is opened with all Queries. 

However, the data is not displayed and I cannot load it to the Power BI either.

Have you ever experienced the same issue before ?

Can you please assist me solving this issue ? 

[amitchandak]

Please refer

https://community.powerbi.com/t5/Power-Query/SAP-BW-Connection/m-p/199887

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-bw

https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

The issue still persists.

Details:

After clicking in Get Data and selecting "SAP Business Warehouse message Server" it is displayed a menu where I need to add some information about the servers, users and so on.

By finishing filling the requirements needed in this menu, I clicked in connect and then I chose the "Windows Logon" as authentication method, then I added the SNC Partner name and clicked in connect.

By doing the steps above, the navigation pane opened with all queries from the BW, but when I select any query the preview is not displayed and the Load button is not able to be used. 

[jshutters]

Connecting to SAP BW is not the easiest, but it sounds like you're on the right path.  You say that you can see the list of queries, so that's sign of progress.  Now try expanding the query that you're interested in, expand down to the dimension/property level, and then check the specific fields that you want to import.