Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
@prateekraina was this ever resolved? I'm currently running into the issue with AIO JIRA pull. Thanks!
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?
Goodmorning Prateek,
I reported the bug, thanks for your help.
Johan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |