Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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)
Solved! Go to 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:
Best regards
Maggie
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:
Best regards
Maggie
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!