Folder Measures - SAP BW Live Connection

Hi  Anonymous ,

Check the limitation for SAP BW in direct query mode:(data view and defining relationships is not supported )

Additional Modeling Restrictions

The primary additional modeling restrictions when connecting to SAP BW using DirectQuery in Power BI are the following:

• No support for calculated columns: The ability to create calculated columns is disabled. This also means that Grouping and Clustering, which create calculated columns, are not available.
• Additional limitations for measures: There are additional limitations imposed on the DAX expressions that can be used in measures, to reflect the level of support offered by SAP BW.
• No support for defining relationships: The relationships are inherent in the external SAP source, and additional relationships cannot be defined in the model.
• No Data View: The Data View normally displays the detail level data in the tables. Given the nature of OLAP sources like SAP BW, this view is not available over SAP BW.
• Column and measure details are fixed: The list of columns and measures seen in the field list are fixed by the underlying source, and cannot be modified. For example, it is not possible to delete a column, nor change its datatype (it can, however, be renamed).
• Additional limitations in DAX: There are additional limitations on the DAX that can be used in measure definitions, to reflect limitations in the source. For example, it is not possible to use an aggregate function over a table.

Here is the related reference:

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