Forum Discussion

cheese_za's avatar
cheese_za
Frequent Visitor
1 year ago

PowerBi getting data from SAP B1 via service layer

I am trying to add this question to my original query, but it doesn't seem to work.   I started testing and ran into an issue. The SAP Partner provided instructions on how to get the data from the ...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi cheese_za ,

 

You need to verify that the SAP B1 Service Layer is correctly set up to accept and process OData requests and ensure that the authentication method is correct.

You can try connecting to Power BI via an ODBC Connection, installing and configuring the ODBC driver.

Here are some helpful links for you:

Datasphere to Power BI via an ODBC Connection - SAP Community

Connecting Microsoft Power BI to SAP data - SAP Community

 

Best Regards,
Zhu

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

cheese_za's avatar
cheese_za
Frequent Visitor
1 year ago

Unfortunately ODBC will not be allowed on this tenant.

 

They advised: "Unfortunately no, ODBC is an old and very insecure option that is not allowed on our cloud. We can't have that open and remain secure unfortunately."

 

I have made some progress with connecting via the Web. If I configure it as per below, I can get all the data:

 

 

I need to test this on a larger table like OINV or INV1. Unfortunately, at the time of writing this post, I cannot access the new server. SAP says: 

 

No company found; contact your system administrator.
 
🤣