Hello,I am using JSON as a data source. I want the user to be able to enter a date in a date picker on a report, and it will go and retrieve data from the JSON feed based on the date the user selected. How would I go about doing this?

erikboderek, You may create a parameter and then reference it in Advanced Editor.

Passing a Parameter to a JSON Data Source | Microsoft Fabric Community

vanessafvg
Community Champion
9 years ago
erikboderek i wouldn't think so because you can't access json data via direct query (unless i have missed that boat)

therefore whatever is brought into the model in import mode is all you can filter by

how are you updating the model currently?
- erikboderek
  Regular Visitor
  9 years ago
  The model is updated by refresh, and the default values are for today. I'd like to use the JSON API instead of having values for dozens of years in my model.
  
  So I can't have a function that calls the JSON feed to retrieve the data based on the date specified, and then filter based on the results of said date?
  - v-chuncz-msft
    Community Support
    9 years ago
    erikboderek,
    
    You may create a parameter and then reference it in Advanced Editor.
Anonymous
Not applicable
6 years ago
erikboderek laurens , I'm also on the same page with this issue, Have you found any solution to this please?