Dynamic Query

Hi GuneetB 
Thank you for reaching out microsoft fabric community forum.

You're right — Web data sources in Power BI only support Import mode, so you can’t link parameters to slicers on the report canvas. A common workaround is to create a table with your space names or IDs using "Enter Data", then add a slicer based on that table. In Power Query, connect to each API URL (one per space), add a column to identify which space the data came from, and append them into one table. This lets users switch between spaces using the slicer, since all the data is already loaded.

Alternatively, if you only want to load data from one space at a time, you can use a parameter in Power Query and manually change its value when needed — this won’t be dynamic through the canvas but avoids editing the full URL.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.