How to use Power BI with SAP

In this video Wessel Verheijen explains how to start building Power BI reports on your SAP source systems and shares three best practices when using Power BI on SAP.

🌐 Stay Connected

⏲️ Timestamps
00:00 – In this episode
00:16 - Introduction
00:44 – Flatten queries
01:07 – Import vs DirectQuery connection
02:48 – Demo: Connecting data to report
04:22 – Summary
05:00 - Outro

Subscribe to learn how to expand YOUR knowledge about SAP functionalities! 💯 New Video Every Week🗓️

ℹ️ More info

🧡 About Us
McCoy TV mission is to give practical insights into SAP and all of their products, both on a technical and business level. We offer quality SAP content-driven videos that are based on our expertise as SAP Consultants. On this channel, you can expect an explanation of SAP functionality combined with practical examples and demos.

💯 McCoy Expertise
» Intelligent Logistics
» S/4HANA
» HR Transformation
» McCoy UX Design
» Intelligent Planning
» Business Intelligence & Reporting

❓ Question
Have a question about Power BI reporting on SAP, other SAP Products, or Anything Else? Post in the comments section of this video!

[kennedylekoko]

How do I connect directly to SAP ECC DB2 from Power BI I tried IBM Db2 connector but it fails.

[dominik]

Hi Wessel,
thank you for the video. In this case you are connecting directly to the HANA database. Is there also a way to connect to CDS Views or Queries or BPC for example? Or do you just do the same and connect to HANA and the CDS views will be shown there?
Best, Dominik

[marnellej]

Hello Wessel, I was able to install the HANA ODBC, but when connecting via POWERBI, being asked for username/password as well as server certificate, I have asked our BASIS and they don't know what rights to assign to the user account that will connect to HANA DB. Just need read-only access right? What can I tell my BASIS ?

[amirbagali]

Hi Wessel, on 3:30, the characteristics are not expandable and hence unable to pull them on screen for development, when we are using PBI service, as against the pbi desktop where they are expandable . Anybody any idea how that can be fixed?

[ARUN-kqdt]

Hey Good Afternoon,
In our Hana DB have more then 2 crores data
Do you have any on this how to connect this much of data into Powerbi
Please provide any solution on this

[egbertdejong]

Hi wessel - usefull thanks! 2 questions though
1) why not use HANA views instead of BEX queries
2) you know how to show in PowerBI go-to-links into SAP ECC e.g. directly opening a workorder in SAP in a new screen SSO?

[franksimms]

Hello,
For financial reporting, do you have a demo of doing this with powerbi? No other tools but powerbi pulling the data from sap for:
Financials - cash flow, income statement and balance sheet?
Thanks

[fabianpassmann]

Hello, thank you for this video!

Not sure if the SAP connections work in both directions or if its just a oneway. Is it possible to upload data from Power BI to SAP? (so the other way arround)
What I am thinking of:
Create a button in Power BI which when clicked uploads a certain data field (for instance a date) to the corresponding data field in SAP.

[virenpatel]

Hi Wessel- Thanks for the video. I had couple of questions : 1. Can we get data for a multiprovider using direct query and Import method. 2. Can get data from Master Data Infoobjects.

[vinaypeyala]

Thanks, Wessel for Providing excellent information Concerning connecting SAP BW data
to Power BI. Is it possible to show flattening Bex query and how we can perform calculations? There is no such videos in You tube.

[shubhamchawla]

Hi
I have a couple of questions:
1. How do I connect SAP S/4 HANA directly with Power BI?
2. Comparison of connectivity with Power BI between SAP HANA, SAP BW and SAP S/4HANA

[franksimms]

Great video. Looking for directions on building operation and financial using SAP and power bi.
Thanks

[krishnadwivedi]

does power BI or tableau is useful for fico consultant in projects i am fico consultant

[texmexdragon]

Great video. Our company is about to migrate to S4 Hana. With the Fiori apps (which seem great), as a Power Bi developer I am a bit worried about my job security since we've always used Power Bi with our current ERP system. Is there a solid use case to continue using Power Bi with S4 Hana given that the Fiori applications seem very powerful?

[adetayoodumade]

Thanks for this video. Please I am having a challenge configuring auto refresh of sap data on power bi

[wesverheijen]

Do you have any questions about this video? Leave them here and I will respond to them personally!

[chetanchauhan]

Please explain in detail
I didnt understood at all

[edwinaragon]

Why don't you show an example as to why bringing in key figures is bad and how it will be wrong. Then show the calculation in power bi