web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
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... / Web Services filtering...
Small and medium business | Business Central, N...
Answered

Web Services filtering data

(0) ShareShare
ReportReport
Posted on by projectaccting20 147

Hi there,

I added Page 950 (Time Sheets) to the Web Services page and the system generated a URL endpoint, which I have brought into Power BI unchanged.

For some reason, the Web Service is only providing a filtered amount of data i.e. one time sheet for one user, instead of several time sheets across several users.

Same applies if I just view the URL in the browser as raw data (Power BI is not itself filtering out anything)

Why is the Web Service filtering the data?

Many Thanks.

I have the same question (0)
  • MahGah Profile Picture
    MahGah 15,613 on at

    Hi

    I could be totally wrong. But could you try to create Web Service for page 951 (Time Sheet List) instead of Page 950 (Time Sheet)?

  • projectaccting20 Profile Picture
    projectaccting20 147 on at

    951 just gives a list of time sheets, not the detail of the lines entered on the timesheets which is what I need.

    However, when I do query the 951 URL the data displayed is complete - unlike 950!

  • MahGah Profile Picture
    MahGah 15,613 on at

    I hope someone can provide the solution. We do not use Timesheet otherwise I could test more. 

  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    Page 950 uses code to show only a single users data. It is not something you can alter without modification. Given these pages hold “active” timesheets you could look at using the “archive” version of the timesheet pages to generate the report. Failing that you will need a modification here.

  • projectaccting20 Profile Picture
    projectaccting20 147 on at

    Okay thanks, I think I will need to look at exposing table 952 as an API endpoint to get all the data I am looking for.

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 Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 607 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 421 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 375 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans