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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Solution Authors
Top Kudoed Authors