Connecting SAP to Powerbi

[emrei]

Hi everyone,

Everyday, I have a dashboard that uses an excel file extracted from SAP. Everyday, I go to SAP and extract a variant report to excel. I then replace the yesterdays excel file with the new excel extraction and refresh&publish my PowerBI.

I am hoping to connect the SAP variant extraction to PowerBI (either directly from SAP to PowerBI or via Microsoft SQL) so I don't have to manually extract the SAP pull and replace the old file everyday. Anyone have any suggestions?

[mlsx4 · Accepted solution]

Hi @emrei 

You shouldn't have problems with connection. You have native connectors in Power BI

And there are hundreds of videos on YouTube and links explaining how to do it: https://www.youtube.com/watch?v=-PgRJ9vcw_E