Forum Discussion

johanfs's avatar
johanfs
Regular Visitor
8 years ago

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

 

 

 

 

 

 

Need Help

7 Replies

  • prateekraina's avatar
    prateekraina
    Memorable Member
    8 years ago

    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's avatar
      johanfs
      Regular Visitor
      8 years ago

      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