Forum Discussion
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 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)
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
1 Reply
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