Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Good day all,
I am trying to filter an API query from a List in BI.
let
Source = Json.Document(Web.Contents("https://qwerty.co/api/v9/qwerty?api_key=1234567890&API_Request_Parameter=list")),
#"Converted to Table" = Table.FromRecords({Source}),
I would like to add a filter after the API key that will itterate through each item in the list.
Regards,
Jason
Solved! Go to Solution.
Eddited for clarity.
Thank you, I had to make some additional changes as the filter list was compiled form an outside source.
https://community.fabric.microsoft.com/t5/Desktop/Formula-Firewall-Query-references-other-queries-so...
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 55 | |
| 48 | |
| 37 | |
| 16 | |
| 15 |
| User | Count |
|---|---|
| 85 | |
| 70 | |
| 38 | |
| 28 | |
| 25 |