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)

Suggested answer

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

Like (1)

Report

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. 20,814 Super User 2025 Season 2 on at

Like (1)

Report

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... 25,373 Most Valuable Professional on at

Like (1)

Report

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

Like (0)

Report

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 (0)

Report

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