Composite model for Direct Query on SAP BW

[SinduN]

Does the Composite Model for Direct Query on SAP BW allow multiple data sources - 2 BW queries or 1 BW query and an excel.

I uenabled COmposite model in options and the Get data button is still greyed out when Im using the direct query option

In in the the Version: 2.60.5169.4101 64-bit  that was released in (July 2018)

[v-juanli-msft · Accepted solution]

Hi @SinduN

According to this article,please pay attention to the notes and the limitations

https://docs.microsoft.com/en-us/power-bi/desktop-composite-models#performance-implications

You'll need to restart Power BI Desktop for the feature to be enabled.

While composite models are in Preview, it is not possible to publish composite models to the Power BI service.

The following multidimensional sources cannot be used with composite models:

• SAP HANA
• SAP Business Warehouse
• SQL Server Analysis Services
• Power BI datasets

Best regards

Maggie