Direct Query connection to SAP BPC

[Anonymous]

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

[Icey]

Hi @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.

[amitchandak]

@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=true

[Anonymous]

Thank you for the reponse. I'm not entirely sure that I understand, as none of the links refer to SAP BPC. Is it possible to create a direct connection to SAP BPC in Power BI?