Forum Discussion

GuneetB's avatar
GuneetB
Frequent Visitor
1 year ago
Solved

Dynamic Query

Hi, I have 2 tables which are fetching data through APIs connected by Web data source. I have created a parameter in order to change the API URL so that i can change the Space i am using.   I now...
Need Help
Show and Tell
  • GuneetB's avatar
    GuneetB
    1 year ago

    Hi,

    Thanks for your help but i took a different route.

     

    I iterated IDs from table 1 on table 2 in order to form a singular table for all the Spaces combined and now using a slicer to filter.

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

GuneetB Consider using a slicer on the canvas by creating a supporting table with possible API URLs or spaces. Then, in Power Query, use this table to dynamically construct the API URL based on the slicer selection.

GuneetB's avatar
GuneetB
Frequent Visitor
1 year ago

Can you please provide an example?

Currently my data source is 

SpaceName = Number.ToText(#"Space ID"),
spaceid = "https://api.xyz.com/api/v2/space/" & SpaceName & "/folder"