Forum Discussion
Direct Query connection to SAP BPC
Greetings,
I need to create a connection to both SAP HANA and SAP BPC, as my BPC data is not present on the SAP HANA server. From my research, it seems like it's only possible to connect to HANA and BW. Is this true?
If at all possible, I want to avoid connecting BPC to Excel through EPM and then have the Power BI connect to the Excel document.
Hope you understand the challenge and are able to help out!
/Ida
3 Replies
Anonymous ,
refer :https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-hana
https://www.youtube.com/watch?v=hcS43uPVu2o
Also check
https://blogs.sap.com/2012/10/26/step-by-step-guide-to-build-an-odata-service-based-on-rfcs-part-1/
https://help.sap.com/saphelp_gateway20sp12/helpdata/en/78/c9223281dc4e48b948a2b278446bb6/content.htm?no_cache=true
https://help.sap.com/viewer/f3e3a9ffe47f4c039ebd1546747288f2/7.52/en-US/55b840530a3ee447e10000000a441470.html
https://help.sap.com/doc/saphelp_nw74/7.4.16/en-US/ec/aeea50ca692309e10000000a445394/content.htm?no_cache=trueHi Anonymous ,
Not sure if this is possible: Microsoft Power BI on top of SAP Data sources : a winning combo ?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
