Forum Discussion
Dynamically Change Data Source Using Parameter and Slicer
Hi, I have Data Source: https://example.com/v1/{city}/api=1.0 . I created parameter (list_param) "List of Value" with City names. I changed the source : Source = Json.Document(Web.Contents(Tex...
Hi Anonymous
Is there a way to change the data source from a report view?
Regards,
Zurab
HI zurab4000,
Query parameter is possible to achieve dynamic change the data source. You only need to parameterize the connection string with query parameters.
Current the slicer and filter not able to directly interact with the backend query tables connection string. I'd like to suggest you submit an idea for these requirements.
Microsoft Power BI ideas
Regards,
Xiaoxin Sheng