Forum Discussion

Franklin1's avatar
Franklin1
Advocate I
9 years ago

SAP - PBI Integration

Hello,   We want to create a report for a third party using their data in SAP. The report will be created using the Desktop BI App by us, and will be shared with the 3rd party using PowerBI (Web)....
Franklin1's avatar
Franklin1
Advocate I
9 years ago

Thanks a lot Xiaoxin,

 

I still need a few more clarifications please:

 

The data I want to get to PowerBI is comng from SAP Business One.

Regarding Q2: Just to make sure I got your point - so SAP Business One is a SAP BW?

As far as I am aware of, there is a way to get data from SAP BW (one of the sources under Get Data is SAP Business Warehouse Server).

Is that correct?

What do I need to be installed in my local machine in order to get data from SAP Business One (see also comment regardint Q1 below).

Regarding Q1: I understand that I need connectors (for SAP BW) / Client (for SAP Hana). The issue is that at this point of time I don't have any SAP License, so I can not download the required Connector/Client. What do I need in order to be able to download it?

 

 Thanks.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Franklin1,

 

>>Regarding Q2: Just to make sure I got your point - so SAP Business One is a SAP BW?

Sorry, it seems like I have misunderstanding of SAP B1.

 

>>What do I need to be installed in my local machine in order to get data from SAP Business One (see also comment regardint Q1 below).

Power bi desktop has the connector of sap bw/hana, current it not support sap b1. About this requirement, I'd like to suggest you submit an idea to ideas forum.

 

>>The issue is that at this point of time I don't have any SAP License, so I can not download the required Connector/Client. What do I need in order to be able to download it?

I think you can get further support at sap forum.

 

BTW, you can also try to use OLE DB and ODBC to connect.

 

Regards,

Xiaoxin Sheng