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

Error while loading data from BC to PowerBi

(1) Share

Report

Posted on by AM-01071407-0

Hi ,

i have a problem while im trying to load the data from BC to Power BI it works for all the table just for purchase Invoice Lines is not working it gives me this error:

DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request. (You must specify an Id or a Document Id to get the lines. CorrelationId: 77c9e642-fc43-4db9-9a84-d79d38f003cc.)

Details:

DataSourceKind=Dynamics365BusinessCentral

DataSourcePath=Dynamics365BusinessCentral

Kind Regards,

Alejna

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Gerardo Rentería Ga... 27,613 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi

Please resend the error message or image.

BR

Gr

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,800 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!

It looks like your screenshot was not posted with your message.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
AM-01071407-0 32 on at

Like (0)

Report
Copy link

Link copied!

Data Source.Error Dynamics365BussinesCentral: Request failed: the remote server returned an error: 400 Bad Request. (You must specify an id or a Document ID to get the lines)
Sorry this is the error

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,903 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Hi, This is very similar to the problem I discussed earlier.

https://yzhums.com/52159/

So, this should be standard control, you need to change your Endpoint or add a filter.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,800 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Yun Zhu is correct, I believe for that API you need to specific the document no./invoice no.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

CU02071649-0 5 on at

Like (1)

Report
Copy link

Link copied!

Please dear sir my id is locked way reason

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,903 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Hi, You can try contacting Community Support.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,698 Moderator on at

Like (2)

Report
Copy link

Link copied!

In PBI you can not pull the Purchase Invoice Lines directly, you need to pull the Purchase Invoices API then in there expand the lines.

Was this reply helpful? Yes No