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?
Solved! Go to Solution.
@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?
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?
Hi there @vanessafvg, I was just wondering if you were able to achieve this as I am looking to do something very similar. I have looked at the 'deep dive into parameters' page but there doesn't seem to be sufficient information. Thank you.
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications