SAP BW Connector (Import Mode) causes composite model failure

[ebeery]

A documented limitation of Composite Models is that using SAP Business Warehouse (BW) as a DirectQuery source is not supported.

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

However, based upon testing, an SAP BW Connector query causes the failure of a composite model in Power BI Service even if the BW Connector query is in Import Mode.

A simple model contains two tables:

- "BW Connector" (uses SAP Business Warehouse Connector, in Import mode)

- "PBI Semantic Model" (DirectQuery connection to a Power BI semantic model)

No measures, calculated columns, calculated tables, or relationships exist in the model.  Visuals for the report are displayed properly in Power BI Desktop.

Upon publish to Power BI Service, the visual using data from the Power BI semantic model (DirectQuery) fails with "There is no available gateway", "An exception occured due to an on premise service issue", and "Error fetching data for this visual" errors.

Removing either table from the model clears the errors and allows data to be displayed correctly. 

Details:

Power BI Version:Version: 2.135.7627.0 64-bit (August 2024)

SAP Connector Details: SAP Business Warehouse Message Server

[Anonymous]

Hi @ebeery 

According to the hints in your screenshot and the documentation, when you use a composite model, if you include a local model (import data from SAP), then you need to create an associated gateway.  Maybe you can try it, create a SAP gateway and see if there is still a corresponding error reported.

Best Regards,
Community Support Team _ Ailsa Tao

[Yasir_Shafique0]

Thanks Dude