Forum Discussion

zenisekd's avatar
zenisekd
Super User
2 years ago
Solved

Connect to SAP BW BEx Query Designer created cubes

Hi, 
our new customer is using BEx Query Designer to create cubes. I was tasked to connect one of those cubes via Power BI Service's Power Query online. 

I did manage to connect to SAP BW Application Server, but I cannot see the cube they mention, when connecting via import mode. 

My questions now is:
1) Can I connect to BEx Query Designer created cube connect with Import mode? 
2) Are there any permissions needed to be granted, so I could see this?
3) Or am I missing something?

Thanks

Need Help

4 Replies

  • johnbasha33's avatar
    johnbasha33
    Super User
    2 years ago

    zenisekd 

    • Import Mode: Yes, you can connect to BEx queries using Import mode in Power BI.
    • Permissions: Ensure the user has the necessary authorizations to access the BEx queries and data in SAP BW.
    • Potential Issues: Verify query settings, connector configuration, and user permissions. Test access with other tools to isolate the issue.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

     

     

    • zenisekd's avatar
      zenisekd
      Super User
      2 years ago

      Thank you for the general answer. 

      The issue is that no one is able to tell me, what permissions I need, including the admin. Also a direction of the query location would be helpful. Any suggestions?

      • foodd's avatar
        foodd
        Community Champion
        2 years ago

        Hello zenisekd.  Please consider directing your question to the SAP Community, especially the Technology Q&A board, where members are friendly and attentive to all matters related to new technology and legacy systems. The URL for posting a new question on that board is as follows:  Technology Q&A | SAP Community

         

        If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.