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)

Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

Hi

Please resend the error message or image.

BR

Gr

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,553 Super User 2025 Season 2 on at

Like (2)

Report

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

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 95,763 Super User 2025 Season 2 on at

Like (2)

Report

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 31,553 Super User 2025 Season 2 on at

Like (0)

Report

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

Please dear sir my id is locked way reason

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (2)

Report

Hi, You can try contacting Community Support.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (2)

Report

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