Record to Report Semantic Model

[Rocky2121]

Wondering if anyone has built out a Record to Report in Power BI? Leveraging data being pulled in from SAP S/4 Hana into Azure. 

Just wondering if anyone has any helpful links or experience creating such a semantic model.

[anupamj]

Hello @Rocky2121 , you will find these useful:

1. Microsoft recommended architecture for PowerBI / Fabric integration with S4HANA (See the semantic models extraction): 

https://techcommunity.microsoft.com/t5/azure-data-factory-blog/integrate-microsoft-fabric-with-sap-d...

1. you can consume directly in PowerBI (here's one record to report F.01) as live or scheduled:https://youtu.be/y-KDyWzOfo4
2. If Azure is the destination for semantic models, you can use USB4SAP 

Questions? please reach out.

Anupam

[v-xuxinyi-msft]

Hi @Rocky2121 

Do you want to connect SAP S/4 Hana to Desktop or Service?

Maybe the following documents can help you:

Power Query SAP HANA database connector - Power Query | Microsoft Learn

Power BI to SAP Connectivity | Microsoft Learn

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.