Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
emrei
Helper I
Helper I

Connecting SAP to Powerbi

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?

1 ACCEPTED SOLUTION
mlsx4
Super User
Super User

Hi @emrei 

 

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

mlsx4_0-1694067755373.png

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

View solution in original post

1 REPLY 1
mlsx4
Super User
Super User

Hi @emrei 

 

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

mlsx4_0-1694067755373.png

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.