Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 service layer. The instructions advises to use Postman and ingest the data via Web connection.
If I try Odata Feed, with the service root URL (https://<server>:50000/b1s/v2), I get the authentication popup followed by this error:
If I try going direct to the resource path items (https://<server>:50000/b1s/v2/items), I get this error:
If I follow the instructions and create an entity, and then and import the data from Web Page, I get the info I want, but only 20 rows.
Here is my get instruction in postman:
In PQE, when click on Source, I get this:
Advanced editor:
1. Is there a configuration issue on the server side preventing my to connect Odata or am I doing it wrong?
2. If I am forced to connect via web page, how do I get more than 20 rows of data?
3. Should I try another connector other than Odata or Web Page?
Thanks for the help.
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.
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:
User | Count |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
93 | |
50 | |
49 | |
46 |