Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to integrate an API with my own data as input.
I have this table and this API:
How can i use the input of my day filter in this API and run this API for each row in the table?
Hi @DionTN,
Which API are you trying to use?
Would be helpful if you could post some of the Power Query code you have so far.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @DionTN,
You can do this using something like Web.Content(), but this needs to be done in Power Query editor (on your screeshot you showing a visual in the report, so you may be thinking about DAX?). In PQ editor you can use Add Column to call API on each row. However, as @Daryl-Lynch-Bzy said, you will need to find the API call details from the API vendor/support.
Kind regards,
John
Hi @DionTN - I am sorry but I don't think this community can help because your query is more specifically related to the api instruction. Please refer to the API Developer instruction provided by FlightStats.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
39 | |
24 | |
21 | |
21 | |
13 |