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

All responses (8)

Answers (0)

Suggested answer

Steven Renders 5,512 Moderator on at

Like (2)

Report

Error while loading data from BC to PowerBi

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.
Suggested answer

YUN ZHU 85,338 Super User 2025 Season 1 on at

Like (2)

Report

Error while loading data from BC to PowerBi

Hi, You can try contacting Community Support.

Hope this helps.

Thanks.

ZHU
Suggested answer

CU02071649-0 5 on at

Like (1)

Report

Error while loading data from BC to PowerBi

Please dear sir my id is locked way reason
Suggested answer

Valentin Castravet 28,288 Super User 2025 Season 1 on at

Like (0)

Report

Error while loading data from BC to PowerBi

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/
Suggested answer

YUN ZHU 85,338 Super User 2025 Season 1 on at

Like (2)

Report

Error while loading data from BC to PowerBi

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
AM-01071407-0 32 on at

Like (0)

Report

Error while loading data from BC to PowerBi

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
Suggested answer

Valentin Castravet 28,288 Super User 2025 Season 1 on at

Like (2)

Report

Error while loading data from BC to PowerBi

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/
Gerardo Rentería Ga... 20,560 Most Valuable Professional on at

Like (1)

Report

Error while loading data from BC to PowerBi

Hi

Please resend the error message or image.

BR

Gr