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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
roumen92
Helper I
Helper I

SAP BW Connector - Cube access

Dear all,

 

We currently had a discussion with our SAP BW provider. We're doing our whole reporting with Power BI and now we want to integrate SAP BW with the connector. Our provider doesn't want to allow this, because he thinks we have access to all cubes and this wouldn't be okay.

 

My question is now: If we install the SAP BW Connector, how can we achieve a solution where we only have access to data from a specific cube? Do we need to set it up with an account, that only has permissions to this specific cube?

 

And is there anywhere a documentation how the connector works? Like a technical documentation?

 

Regards,

Roman

1 ACCEPTED SOLUTION

Hi @roumen92,

 

1. I mean, with what credentials do I have to sign in againt the SAP server? Because I don't see a point in the documentation where I have to type in my credentials.

 

When get data from the SAP BW in Power BI desktop, it uses a user ID and a password for logon. See: Logon and Password Security in the ABAP-System.

 

q3.PNG

 

 

2. Or how do we have to secure it on SAP side? Does anybody ever had this problem to be only allowed to access one single cube?

 

Power BI exposes queries and cubes exposed by the BW Open Analysis Interface OLAP BAPIs. The SAP BW logon user and permission setting are done on SAP BW side. You can contact your SAP BW administrator for help. Also you can post a question in SAP BW forum.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-qiuyu-msft
Community Support
Community Support

Hi @roumen92,

 

To limit the user to access the specific SAP BW cube, the permission should be set on SAP BW side, you can contact your SAP BW administrator for help.

 

There is a official document which introduces SAP BW connector in Power BI desktop, please take a look: Use the SAP BW Connector in Power BI Desktop.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-qiuyu-msft

 

Thank you for your input. But it isn't quite clear to me. 

 

I mean, with what credentials do I have to sign in againt the SAP server? Because I don't see a point in the documentation where I have to type in my credentials.

 

Or how do we have to secure it on SAP side?

 

Does anybody ever had this problem to be only allowed to access one single cube?

 

Roman

Hi @roumen92,

 

1. I mean, with what credentials do I have to sign in againt the SAP server? Because I don't see a point in the documentation where I have to type in my credentials.

 

When get data from the SAP BW in Power BI desktop, it uses a user ID and a password for logon. See: Logon and Password Security in the ABAP-System.

 

q3.PNG

 

 

2. Or how do we have to secure it on SAP side? Does anybody ever had this problem to be only allowed to access one single cube?

 

Power BI exposes queries and cubes exposed by the BW Open Analysis Interface OLAP BAPIs. The SAP BW logon user and permission setting are done on SAP BW side. You can contact your SAP BW administrator for help. Also you can post a question in SAP BW forum.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

One easy way to access SAP data from the source ECC system, rather than extracting it a second time from SAP BW, is through Simplement's Data Liberator.  This platform surfaces any SAP ECC (or CRM) table in real-time, and puts it directly into SQL Server, ready for Power BI.  

 

                     http://www.simplement.us/

 

Mike McNally

SAP BW specialist

mmcnally@simplement.us

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors