Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Items table not reachable
Small and medium business | Business Central, N...
Suggested answer

Items table not reachable

(1) ShareShare
ReportReport
Posted on by Aurelio 61
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
  • Aurelio Profile Picture
    Aurelio 61 on at
    Items table not reachable
    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
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 84,621 Super User 2025 Season 1 on at
    Items table not reachable
    Are you using a standard API or a web service? It would be helpful if you could provide some screenshots.
     
    Thanks.
    ZHU
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 19,937 Most Valuable Professional on at
    Items table not reachable
    Hi
    Could you review this information, I hope it helps you.
    Best
    GR
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 17,404 Super User 2025 Season 1 on at
    Items table not reachable
    Checking for network or performance issues, and ensuring Power BI's data source connection is valid. Also, verify permissions recent changes.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 28,279 Super User 2025 Season 1 on at
    Items table not reachable
    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?
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans