BW Connector displaying all cubes or queries

[abbas_uddin]

Dear Experts,

As a beginner, i have no idea how to resolve User access for SAP BW displaying all standard cubes and custom queries.

The issue is we are group company and i have setup a connector from PBI with SAP BW for one company. The user logged in with his own SAP ID and noticed that the person is able to see all queries which i have developed at group level. The question is how can we restrict access to only see that specific company queries. The BASIS team setup his SAP ID and gave access to only one company. and still he sees other developed queries. When i tried to run the query only his company data was showing (which is acceptable). But still can confuse the user with so many queries and standard cubes appearing. 

Your input is appreciated

[v-kelly-msft]

Hi  @abbas_uddin ,

Check and trace whether the users have certain access to the various MDPROVIDER modules and BAPI_IOBJ_GETDETAIL.     

For the related reference,pls see below:

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

Best Regards,
Kelly

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