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

Power BI

(1) Share

Report

Posted on by Community member

I am getting the error below when trying to connect to Standard APIs

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: 39db6ed0-2b60-4b60-95ce-512c54b242b8.)
Details:
DataSourceKind=Dynamics365BusinessCentral
DataSourcePath=Dynamics365BusinessCentral
Url=https:/api.businesscentral.dynamics.com/v2.0/PRODUCTION/api/v2.0/purchaseInvoiceLines?company=xxxxxxxxxx

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community member 2 on at

Like (0)

Report

Power BI

as per the "error: (400) Bad Request. (You must specify an Id or a Document Id to get the lines." it means either you are using a wrong URL or wrong way to filter OData.

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 23,590 Most Valuable Professional on at

Like (0)

Report

Power BI

Hi

I hope this can help you

https://community.fabric.microsoft.com/t5/Developer/Connecting-to-Dynamics-365-Business-Central-API-v2-0/m-p/2243041

https://community.fabric.microsoft.com/t5/Desktop/Error-400-when-loading-big-file-from-Dynamics-365-Business/td-p/2028376

BR

Gr

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 93,222 Super User 2025 Season 2 on at

Like (0)

Report

Power BI

It seems to be a problem with your Endpoint.
Another question I have is that when selecting APIs or Web Services in Power BI, there is no need to enter a URL.

If you added the OData feed manually, please pay attention to adding the following filter.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Judy Microsoft Employee on at

Like (0)

Report

Power BI

Hi, for the error messages, please go to the Web Services page to make sure the Web Service is Published so it's accessible.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/publish-web-service

Was this reply helpful? Yes No

Join the conversation

Community site session details

Power BI

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Power BI

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates