Edit query filter doesnot work for some (bigger) files using Odata feed

[johanfs]

We use Odata feed in Power BI desktop to get data from an external party.

After the data is loaded in the model I use Edit Query to filter the data.

But for some bigger files this filter doesnot work at all.

When i use the filter in the report it works fine.

Is this a known problem?

Any idea how to solve it?

Thanks,

Johan

[prateekraina]

Hi @johanfs,

Kindly provide more detals on what actually is happening in the Query Editor.

For Example: The length of the sring or any screenshot would be helpful in solving your query.

Prateek Raina

[johanfs]

This is the code you see in the advanced Editor:

let
    Source = OData.Feed("https://opendata.cbs.nl/ODataFeed/odata/83765NED"),
    TypedDataSet_table = Source{[Name="TypedDataSet",Signature="table"]}[Data],
    #"Filtered Rows" = Table.SelectRows(TypedDataSet_table, each ([ID] = 1))
in
    #"Filtered Rows"

I took the most simple filter that should result in only 1 record, but I get all the records.

I will add a screenshot so you can see the result (even after refreshing) still shows all the records.

Thanks,

Johan

[johanfs]

Result after filter 

[prateekraina]

Hey @johanfs,

You are right. This is a bug. Filtering is not working in Query Editor.

You should log this bug in Issues forum. They will get it resolved.

Put the issue link here after you post it. I will also +1 that bug.

Prateek Raina

[Anonymous]

@prateekraina was this ever resolved? I'm currently running into the issue with AIO JIRA pull. Thanks!

[Anonymous]

Hi,

I am currently facing the same problem. I tried filtering out a particular column in a table in the query editor. But when I 'Close & Apply' the changes to Desktop, the filtering has not taken place and all the values in the column show up anyway.

Did anybody find a solution to this?

[johanfs]

Goodmorning Prateek,

I reported the bug, thanks for your help.

Johan