Dynamic Query

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.

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.

Hi GuneetB 

It's great to hear that your issue has been resolved. Please accept the reply as the solution. This will help other community members solve similar problems more quickly.

Thank you.