How do I filter OData results by date or property in Power BI?

Filters let you control how much data your OData connection pulls in by telling it to only return rows that match certain conditions. Instead of loading everything and filtering inside your reporting tool, you're trimming the data at the source — which means faster load times and cleaner reports.

How it works

You add a filter by appending a $filter parameter to the end of your OData entity URL. The format looks like this:

?$filter=PropertyName operator 'value'

For example, to return only inspections updated after January 1, 2024:

?$filter=UpdatedAt gt '2024-01-01T00:00:00Z'

You can combine multiple filters using and:

?$filter=UpdatedAt gt '2024-01-01T00:00:00Z' and CompletedAt gt '2024-01-01T00:00:00Z'

Note: Filters are applied to specific entity URLs (like /schedules or /scheduledinspections), not the root URL (like /inspections).

Filter operators

What you can filter on

Not every column supports filtering. Below is a full list of filterable columns by table.

Weever Forms

Submission data (all form tables) :    _id, Form_Created_Date, Form_Created_By, Form_Created_By_Email, Form_Updated_Date, Ticket_Created_Date, Ticket_Updated_Date, Ticket_Updated_By, Ticket_Updated_By_Email, Ticket_Status, Ticket_Time_To_Close, Ticket_Assignee, Ticket_Assignee_Email, Ticket_Comments, Ticket_Due_Date

Note: For forms, filter property names must be written in camelCase (e.g. FormCreatedDate, not Form_Created_Date).

FormMetrics:     Date, FolderId, FolderName, FormId, FormName, FormCreatedAt, FormDeletedAt, FormStatus, SubmissionsTotal, UniqueSubmittersTotal, SubmissionsPointsTotal

User :     Id, FirstName, LastName, Email, UserType, Status, JoinedAt, LatestUpdatedAt, PhoneNumber, EmployeeNumber, TicketCreatorNotificationsEnabled, LatestFormSubmissionAt

DatabaseItem :     DatabaseId, DatabaseName, TierId, TierName, TierLevel, Id, ParentId, Name, Note, Status, CreatedAt, UpdatedAt, ArchivedAt

Weever Inspections

Schedules:     ScheduleId, InspectionTypeId, InspectionTypeName, AssetId, AssetName, FormId, FormName, ShiftId, ShiftName, AssigneeId, AssigneeName, Frequency, DayOfWeek, StartDate, ExpectedDurationMinutes, Status, Note, CreatedAt, CreatedById, UpdatedAt, UpdatedById

ScheduledInspections:     ScheduleId, InspectionId, InspectionTypeId, InspectionTypeName, AssetId, AssetName, FormId, FormName, FormSubmissionId, ShiftId, ShiftName, AssigneeId, AssigneeName, ExpectedDurationMinutes, TotalChecks, PassedChecks, FailedChecks, NAChecks, Status, DueAt, CompletedAt, CompletedById, CompletedByName, UpdatedAt, UpdatedById, UpdatedByName

Weever Process

Process submissions :     FormId, FormName, Id, Status, CreatedAt, UpdatedAt, SkippedAt, SkippedByName, SkippedReason, UpdatedByEmail

Process :    ProcedureId, CategoryId, CategoryName, DepartmentId, DepartmentName, LineWorkAreaId, LineWorkAreaName, Id, Name, Status, StartedAt, StartedById, StartedByEmail, StartedByName, LastUpdatedAt, ClosedAt, ClosedById, ClosedByEmail, ClosedByName, SummaryFormId, SummaryFormVersion, SummaryFormName, SummarySubmissionId, SummarySubmissionVersion, SummarySubmissionStatus, SummarySubmissionCreatedAt, SummarySubmissionUpdatedAt

ProcessTask :    ProcedureId, ProcedureVersion, CategoryId, CategoryName, DepartmentId, DepartmentName, LineWorkAreaId, LineWorkAreaName, MachineId, MachineName, ProcessId, ProcessName, StepId, StepName, StepSortOrder, Id, Name, SortOrder, CreatedAt, UpdatedAt, UpdatedById, UpdatedByEmail, DueAt, Status, Priority, RepetitionValue, RepetitionUnits, RoleId, RoleName, AssigneeId, AssigneeEmail, FormId, FormVersion

Department, LineWorkArea, MachineType, Machine, Shift :     Id, Name, Status, Notes, CreatedAt, UpdatedAt, DeletedAt (plus DepartmentId / LineWorkAreaId / MachineTypeId where applicable)

User (Process) :    Id, Email, FirstName, LastName, Phone, EmployeeType, Status, StatusReason, CreatedAt, UpdatedAt, DeletedAt, PasswordChangedAt, ResetPasswordSentAt, CurrentSignInAt, LastSignInAt, CurrentSignInIp, LastSignInIp, SignInCount