We'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.
| User | Count |
|---|---|
| 56 | |
| 40 | |
| 36 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 38 | |
| 34 | |
| 23 |