Power Platform Community Forum Thread Details

I can't filter OData query data at the source without generating a hand-authored queries error

I have some OData queries that retrieve data from Azure. These queries are quite large, and I need to filter the data at the source to work with it effectively. However, if I include filters in the OData query at the source, I encounter an issue when publishing to Power BI - I receive the error 'some data sources may not be listed because of hand-authored queries.

Is there a way to filter the data at the source without causing this publication problem?

Below is one of my OData queries

let
Fonte = OData.Feed(
Link_Azure & "/WorkItemRevisions?" &
"$apply=filter(" &
"WorkItemType in ('Feature', 'Technical Feature','Incident','Bug','User Story','Technical Story') " &
"and (Area/AreaLevel3 eq 'ABAX'" &
"or Area/AreaLevel3 eq 'HBNFe'" &
"or Area/AreaLevel3 eq 'Thoth'" &
"or Area/AreaLevel3 eq 'Belaz'" &
"or Area/AreaLevel3 eq 'Aurora Sirius'" &
"or Area/AreaLevel3 eq 'Promax'" &
"or Area/AreaLevel3 eq 'Novo ABdocs'")" &
"and CreatedDate ge " & DateTime.ToText(DateTime.FromText("2023-07-01T00:00:00Z"), "yyyy-MM-ddTHH:mm:ssZ") & ")" &
"&$orderby=WorkItemId desc, Revision Desc" &
"&$select=WorkItemId, Revision, RevisedDate, Title, WorkItemType, ChangedDate, CreatedDate, State, Reason, ActivatedDate, ClosedDate, ResolvedDate, DueDate, FinishDate, StartDate, StateChangeDate, Custom_Impediment,Area",
null,
[Implementation="2.0"]
)
in
Fonte