cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Passing a Parameter to a JSON Data Source

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Passing a Parameter to a JSON Data Source

@erikboderek,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Highlighted
Super User I
Super User I

Re: Passing a Parameter to a JSON Data Source

@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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: Passing a Parameter to a JSON Data Source

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?

Highlighted
Community Support
Community Support

Re: Passing a Parameter to a JSON Data Source

@erikboderek,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Super User I
Super User I

Re: Passing a Parameter to a JSON Data Source

oh thats awesome thanks @v-chuncz-msft





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: Passing a Parameter to a JSON Data Source

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.

Highlighted
Anonymous
Not applicable

Re: Passing a Parameter to a JSON Data Source

@erikboderek  @laurens , I'm also on the same page with this issue, Have you found any solution to this please?

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors