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
It is possible to define a paramateric SQL query which can be updated in real-time based on the selected value in a slicer. But it seems that it is limited to the data sources that supports DirectQuery. In this ragard, these two links should be useful:
However, I am still looking for a way to apply the same scenarion on the WEB (RestAPI) data source. Please let me know if you find any solution.
Best regards, Hossein.