Power BI - SAP BO1 Integration

[StefanoGrimaldi]

hey guys, 

have anyone done a integration from power bi or powerapps where you send data back to sap or make from power platform send a function trigger with the fields parameters for those function and run it on sap? 

example adding a new item to the item master on sap lets say

any tips or suggestion would be much appreciated here

[CDLM]

Dear All,

 I need to connect Power Bi to Sap B1, What kind of connectors do I need ? Sap B1 is running on cloud right now , i don´t have local server, SAP is hosted in cloud !

I think i need credentials from the Hosting provider , but i need some connectors before !

I need some guidance, if you have any ideas i would appreciate it !

Regards

[lbendlin]

- at the moment it's either PowerApps or R/Python scripts

- there is no data write back closed loop yet - your change will not be reflected in Power BI until the next dataset refresh or direct query - this makes for an awkward UX.

[StefanoGrimaldi]

but by any change have you a examplle been able to write back to SAP even if it doesnt reflect until next refresh, looking for a example of succesfully writing back from powerapps to SAP

[lbendlin]

Introducing the SAP ERP connector | Microsoft Power Apps

[StefanoGrimaldi · Accepted solution]

hey this didnt work cause the conector its formated to work on sap hana s/4 not SAP BO1, found a solution to make a little integration, creating a asp.net hosting and creating a apis that call upon the parameters from powerapps and them send over to the SAP intefarce.