Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
zenisekd
Super User
Super User

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

1 ACCEPTED SOLUTION
zenisekd
Super User
Super User

So, after some time spent, I managed to find out, that the SAP administrator must enable external users to access the OLE DB for OLTP

zenisekd_0-1719310189672.png

After checking this, the queries got visible after some time. 

I must credit this video: https://www.youtube.com/watch?v=w2Vt-oGhmxU&t=464s&ab_channel=KnowledgeBankbyobviEnce

View solution in original post

4 REPLIES 4
zenisekd
Super User
Super User

So, after some time spent, I managed to find out, that the SAP administrator must enable external users to access the OLE DB for OLTP

zenisekd_0-1719310189672.png

After checking this, the queries got visible after some time. 

I must credit this video: https://www.youtube.com/watch?v=w2Vt-oGhmxU&t=464s&ab_channel=KnowledgeBankbyobviEnce

johnbasha33
Solution Sage
Solution Sage

@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 !!

 

 

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?

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.