Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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...
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 55 | |
| 40 | |
| 35 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 71 | |
| 70 | |
| 38 | |
| 35 | |
| 23 |