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

Items table not reachable

(1) Share

Report

Posted on by Aurelio

Good afternoon

Since two days it is not possible to reach the items table. We use this in PowerBi. We also tried to make another webservice but it also keeps loading.

Does somebody knows how to solve this?

Thank you in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

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

Like
a
(1)

Report
Copy link

Link copied!

Are you receiving an error message, or is the web service simply not visible in Power BI? Or do you see it but it isn't loading any data?

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

Khushbu Rajvi. 23,132 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Checking for network or performance issues, and ensuring Power BI's data source connection is valid. Also, verify permissions recent changes.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 27,507 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

Could you review this information, I hope it helps you.

Power BI Dataset Load Performance - Business Central | Microsoft Learn

Best

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,361 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you using a standard API or a web service? It would be helpful if you could provide some screenshots.

Thanks.

ZHU

Was this reply helpful? Yes No
Aurelio 84 on at

Like
a
(0)

Report
Copy link

Link copied!

An API was built but as back-up we also used a webservice.

- The webservice:

https://api.businesscentral.dynamics.com/v2.0/COMPANY/Production/ODataV4/Company(COMPANY)/Artikel_Excel?$select=No,Blocked,Inventory,Qty_on_Purch_Order,Qty_on_Prod_Order,Qty_on_Component_Lines,Qty_on_Sales_Order&$filter=(startswith(No,'H') or startswith(No,'P'))

- Permissions are valid

- Not even possible to 'edit in excel' on items table. The items table is the only one who is affected at the moment.

- The error:

DataSource.Error: Dynamics365BusinessCentral: Request failed: The operation has timed out. DataSourceKind = Dynamics365BusinessCentral. DataSourcePath = Dynamics365BusinessCentral. ;Dynamics365BusinessCentral: Request failed: The operation has timed out. The exception was raised by the IDbCommand interface. Table: items.
URI cluster: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net

Was this reply helpful? Yes No