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
zurab4000's avatar
zurab4000
Frequent Visitor
3 years ago

Hi Anonymous 

Is there a way to change the data source from a report view?

 

Regards,

Zurab

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • Farhad88's avatar
    Farhad88
    Helper I
    2 years ago

    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:

    https://youtu.be/L-wqwzj0-Xo

    https://learn.microsoft.com/en-us/shows/mvp-azure/pass-parameter-to-sql-queries-statement-using-power-bi

     

    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.