web

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

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,518

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
Copy link

Link copied!

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,518 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,518 on at

Like (0)

Report
Copy link

Link copied!

Ah! Thanks, S_LEcuyer!

John

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

OussamaSabbouh 2,173 Super User 2026 Season 1

#2

Dhiren Nagar 1,201 Super User 2026 Season 1

#3

YUN ZHU 1,164 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans