topic Re: Power BI - SAP BO1 Integration in Developer

Power BI - SAP BO1 Integration

StefanoGrimaldi — Thu, 14 Oct 2021 11:44:07 GMT

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

Re: Power BI - SAP BO1 Integration

lbendlin — Sun, 17 Oct 2021 00:42:03 GMT

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

Re: Power BI - SAP BO1 Integration

StefanoGrimaldi — Sun, 17 Oct 2021 13:33:41 GMT

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

Re: Power BI - SAP BO1 Integration

lbendlin — Sun, 17 Oct 2021 18:29:06 GMT

Introducing the SAP ERP connector | Microsoft Power Apps

Re: Power BI - SAP BO1 Integration

StefanoGrimaldi — Tue, 19 Oct 2021 11:44:27 GMT

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.

Re: Power BI - SAP BO1 Integration

CDLM — Sat, 11 Nov 2023 16:18:05 GMT

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