Connector missing between (SAP) CFIN and Power BI?

[Mar1604]

Hi, could it be that there's no connection possible between (S/4) CFIN and Power BI? We're not allowed to connect directly to SAP, but in the old situation there was a connector between SAP BW and Power BI, but it seems there's no connector for CFIN.

[Mar1604]

Thanks for your clear and quick response. It's highly appreciated.

[v-achippa]

Hi @Mar1604,

Thank you for reaching out to Microsoft Fabric Community.

Yes there is no dedicated connector labelled for SAP (CFIN) in power bi. This is because CFIN is built on top of SAP S/4HANA so there is no out of the box connector specifically to it.

Since direct access is not allowed consider extracting CFIN data to a staging layer like Azure Sql, Data Lake or Microsoft Fabric Lakehouse so that power bi can easily connect to all of these.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[Mar1604]

Hi Anjan,

Thank you for you answer. It seems a bit strange that we need to duplicate/replicate the same data in Fabric as we put in CFIN but would you know if it's possible to use also the same SAP SLT connector that most probably was used between S/4 and CFIN? 

[v-achippa · Accepted solution]

Hi @Mar1604,

Thank you for the response, the SAP SLT does support multi target replication. So if you are already using SLT to replicate data into CFIN, it can also be configured to replicate the same data to another target like Azure Sql Database, Azure Synapse Analytics and Azure Data Lake.

Once the data is available in one of these intermediate layers, Power BI or Microsoft Fabric can easily connect to it for visualization and reporting. While direct SLT to Fabric integration is not available, this method allows to reuse the existing SLT flows and no need of duplicating the extraction logic.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa