Forum Discussion

SinduN's avatar
SinduN
Helper I
8 years ago
Solved

Composite model for Direct Query on SAP BW

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 grey...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

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