- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Setting dynamic parameters from final user to Power Query URL source
Hello there,
I'm facing a challenge that I'm hoping you can help me out to solve,
I have 2 queries both are calling API's by using an URL:
The 1st one is returning a list of events, including a column that contains a single ID for each event.
The 2nd one is returning detailed info for each event, where this query uses a single ID at the end of the calling url, and gives me info only for that specific ID wrote in the calling url, where if I want to see the info related to a different event I have to manually change it by going to Power Query and editing it in the calling url for the api.
My main objective is to fully automate this manual process, by setting something that allows to the final user (even when the report is published in the online service) to select a value from the 1st query, and use that selection as a parameter to be included in the 2nd query calling url.
I've been trying so without no luck, and now I'm hoping anyone of you could help me with this?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Doing this depends on what connector you are using. For Web.Contents, this won't work as it doesn't directly support direct query (you would have to build your own connector). If your data source does support direct query, then I would need more details to determine what the issue is.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi artemus,
I'm using Web.Contents as I understand this is the only way to connect to a Rest API.
Could you advise if it's possible to connect to the rest api by using direct query?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-31-2023 07:51 AM | |||
09-16-2022 12:24 AM | |||
07-29-2024 08:01 AM | |||
01-10-2023 09:00 AM | |||
10-02-2023 05:59 AM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
9 |