How can we improve Power BI?

SAP

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.

442 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    43 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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!

      • Florian commented  ·   ·  Flag as inappropriate

        Many of our customers and partners ask for this, we would require it as well.

      • Dahyana Parejo commented  ·   ·  Flag as inappropriate

        excellent tool to consolidate effective reports and effective management of information, however, it needs to be updated in terms of speed in data processing according to the configuration of some layouts

      ← 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.