Forum Discussion
Integrating SAP with Power BI
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 sour...
netanel
Post Prodigy
Post ProdigyHi 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