How can we improve Power BI?


Connect to SAP BW with single-sign-on via on-premise gateway

Large SAP BW installations with thousands of users are often accessed via single-sign-on (SSO) e.g. the users windows credentials are used to authenticate to BW. SSO simplifies the user experience and reduces user administration costs. These users should be able to setup on-premise gateway connections that can be used to refresh data sets in the Power BI Service. The connections should leverage that individuals BW roles & authorizations and not require a BW password i.e. automatically associate the Power BI user ID to the associated SAP user ID.

849 votes
Sign in
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: Facebook Google
Signed in as (Sign out)
  • David commented  ·   ·  Flag as inappropriate

    Please prioritize this, we need this connectivity working ASAP

  • Anonymous commented  ·   ·  Flag as inappropriate

    I dont know why its here , because I am able to do it using Single sign on I am using Message Server connectivity with >net connector and using Kerberos authentication. All you need is SAP Partner name which you can get from SAP Logon of your organization. No password required while connecting to SAP BW.

    Correct me if i am wrong

  • Alessio commented  ·   ·  Flag as inappropriate

    Not only for BW but for ECC as well.
    All main companies use SAP, the effort of replicating and keep securities syncronized on a datawarehouse for powerBI stops powerBI growth

  • Anonymous commented  ·   ·  Flag as inappropriate

    We are using SAML to authenticate to our SAP ECC. Support for SAML would be great.

  • vishwanath commented  ·   ·  Flag as inappropriate

    We need this in our organization as we have to leverage existing BW roles and authorizations instead of controlling the access at the report or a work space level.
    Because of this missing SSO we are unable to use the power BI .

  • Anonymous commented  ·   ·  Flag as inappropriate

    We need this in our organization!!
    If this is possible, we will increase Power BI usage dramatically.

  • Chris Wright commented  ·   ·  Flag as inappropriate

    This is probably the single biggest barrier to further adoption and users in our company.

  • Paulo Monteiro commented  ·   ·  Flag as inappropriate

    Connecting to BW via Direct Query in very large BW systems has some advantages but many disadvantages, including slowness and loss of many Power BI key features such as data mashup and transformations. As such, we do not recommend this option in our environment. With Import we can bring transparently the set of data the users need closer to them and allow them to mashup (adding local groupings and hierarchies) and add useful transformations that allows fixing wrong data, adjusting formats etc. However, the Import method does not have Cloud refresh, forcing users to refresh at desktop level and re-publish the whole set again and again. The new BW connector added spedd and mass processing capabilities, which is great. However, without the option to refresh Imported data in the cloud we still have no viable BW connection option to recommend to our users.

  • Will Block commented  ·   ·  Flag as inappropriate

    We are running HANA on top of BW and RLS is established at the BW layer. We need the above stated issue to be resolved in order for RLS to work properly...

  • Roman commented  ·   ·  Flag as inappropriate

    In our organisation we are using BW and the only way allowed to authenticate is SSO, which makes it impossible to use BW from PBI Cloud without possibility to pass credentials through the gateway.

  • Mark C commented  ·   ·  Flag as inappropriate

    Totally agree and have voted however the experience and accuracy of retrieving content from SAP BW needs a lot of work too!

← Previous 1 3

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.