Skip to main content

Power BI

Needs Votes

Friendly query list when connecting to SAP BW

Vote (16) Share
's profile image

on 22 Sep 2017 07:34:34

When users connect to a SAP BW data source they are presented with the SAP BW back-end InfoArea hierarchy. This is highly technical in nature and often not primarily designed to be user facing but instead used to manage layered data architectures, security, etc.

Given this, it would be desirable to be able to present an alternative information architecture; a curated, more user friendly layout of queries that are meaningful for analysis in Power BI.

Without such a friendly, understandable structure – there can be difficulty in a user finding information and hence potential adoption issues for BW data sources. For some customers SAP BW is their central data management platform - hence this can be quite important.

Whilst there are alternatives to enabling an alternative information hierarchy, such as providing a series of reports with pre-canned connections, or links on a page that use APIs to connect to data sources, it'd be nice to have something native within Power BI.

Are there any options here to curate this list into something more friendly and provide an alternative, non-technical information architecture?

Comments (1)
's profile image Profile Picture

Power BI User on 05 Jul 2020 23:18:31

RE: Friendly query list when connecting to SAP BW

Agreed, Having the ability to show the name of the objects would be much better. I realize that you have the ability to toggle to technical names but for the most part the technical names are already displayed. Having the option to show the short or long description would be a very nice addition.