Forum Discussion

zurab4000's avatar
zurab4000
Frequent Visitor
3 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi zurab4000,

AFAIK, slicer and query parameter are work on different level, you can’t use the front side slicer to affect the background query parameters.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng