Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric certified for FREE! Don't miss your chance! Learn more
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 January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 68 | |
| 59 | |
| 44 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 104 | |
| 103 | |
| 37 | |
| 27 | |
| 26 |