cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johanfs Frequent Visitor
Frequent Visitor

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

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

 

 

 

 

 

 

7 REPLIES 7
prateekraina New Contributor
New Contributor

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

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 Frequent Visitor
Frequent Visitor

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

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 Frequent Visitor
Frequent Visitor

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

filterissue.JPGResult after filter 

 

prateekraina New Contributor
New Contributor

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

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

johanfs Frequent Visitor
Frequent Visitor

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

Goodmorning Prateek,

 

I reported the bug, thanks for your help.

 

Johan

kfredette Occasional Visitor
Occasional Visitor

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

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

PPRP Frequent Visitor
Frequent Visitor

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

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?

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 294 members 2,823 guests
Please welcome our newest community members: