Integrating SAP with Power BI

[Anonymous]

As a business owner, I am seeking help from techies who have experience in integrating SAP with Power BI. I am particularly interested in understanding the best practices for connecting SAP data sources to Power BI, as well as the most effective ways to create reports and dashboards using Power BI.

Any advice, tips, or resources on this topic would be greatly appreciated. Thank you in advance for your help.

[netanel]

Hi @Anonymous 

Hi, I managed to connect a variety of SAP tools
To Power Bi
From my experience, the easiest way is to connect through SQL Server
SAP, like other systems, is built in such a way that it is very easy to extract a star Schema from it and easily build in the Power Bi dimensions and a Fact table
If it is not a large connection, there is the export Excel to a folder and create a connection to the folder from Power Bi
If something automatic is needed, I recommend a connection to SQL

Good Luck