Forum Discussion

daanp's avatar
daanp
Frequent Visitor
10 years ago

SAP BW authorization

Hello all,

 

Recently we've started working with the SAP BW connector. It works great. 

 

When we check the 'allow external access'  box in BW. the query is available in Power BI. But it is available for everyone who has access to the BW server, not just the people who have specific authorization in BW to the query.

 

Question:

Is it possible for Power BI to connect to BW and follow the same authorizations in BW?

 

or is there another solution?

 

Any tips and tricks

Need Help

8 Replies

  • JuandreR's avatar
    JuandreR
    Advocate I
    8 years ago
    I have done quite extensive research on this topic; Power BI cannot handle structural auths from SAP. The only auths you can set up for Power BI is on Active Directory. It is not even remotely close to SAP structural auths, it is extremely difficult "nearly impossible" to manage in the long run, if you are in a large corporation. For example, you need to keep track of employees and have a record of which groups in AD each employee is part of. The reason behind this is because you need to adjust those when an employee transfers into a different position in the company / resigns, etc.. It is something that Microsoft seriously needs to look into, since more and more companies are trying to implement Power BI on top of an SAP Data warehouse.
  • Goulwen's avatar
    Goulwen
    New Member
    9 years ago

    Hi experts,

     

    I have the same questions, I could secure my BW data swithout develop a new security ?

     

    Thank a lot.

     

    Goulwen

  • JuandreR's avatar
    JuandreR
    Advocate I
    9 years ago

    Hi Daanp,

    Did you ever manage to get this done?
    We are also moving into MS Power BI and all our data currently resides within SAP BW, so we would also like to use the current structural authorizations from SAP BW instead.

    If not, how did you manage to do it?

    • JuandreR's avatar
      JuandreR
      Advocate I
      9 years ago
      v-qiuyu-msft , Do you possibly have a solution to this, or is this a planned feature for the near future in Power BI?
  • kotians's avatar
    kotians
    Regular Visitor
    9 years ago

    Hello

    i have simialr question. does any one has solution for this?

    how to powerbi handle bw authorization?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Even we are looking to leverage the existing BW authorisation. Any inputs will be much appreciated

  • vpo's avatar
    vpo
    New Member
    8 years ago

    Dear PowerBI Community,

     

    I have the same question, as we want to connect SAP BEx Queries but we need to use the SAP authorizations behind them. Is there a way to do this?

     

    Kind regards,