web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Selecting "purcha...

Small and medium business | Business Central, N...

Answered

Selecting "purchaseOrderLines" in Power BI

(0) Share

Report

Report

Posted on by john.ellis

3,510

Hi:

In Power BI's "Get Data", I'm trying to pull in the "purchaseOrderLines" Standard API from Business Central Online Services.

I get the error shown below.

How can I eliminate this error?

Thanks!

John

6201.Capture.PNG

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Suggested answer

Akshay_Panchal 402 on at

Like (0)

Report

Hii,

You have to add one more parameter on API url with name document Id = sales line document no.

Thanks.

Verify, if this answer helpful to you.

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

I didn't create the API.

So, how do I do this?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

I also get similar error messages. These APIs option are new (I've just recently noticed them), Is Microsoft still Beta testing them...

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Ah! Thanks, S_LEcuyer!

John

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 3,151

#2

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans