Pass Users' Parameter into json query url

[Asantos2020]

Hello,

I'm not sure I've found a definite No to this.

I am pulling data via a url, but this needs to have its StartDate defined by a parameter where the user can define the number of months back the data is supposed to be.

So, accessing the report today, the data should be from July/28th to Nov/28. 

I've been trying to pass a Query Parameter below, but although the Current Value says it's 4, I'm getting data from the whole year:

Json.Document(Web.Contents("https://api.com.br/Server_2.0.0_api/PBI/documents/data?FromDate="&Date.ToText(DateTime.Date(Date.Add...(), -MonthParameter)))&"&ToDate="&DateTime.ToText((DateTime.LocalNow()), "yyyy-MM-dd")&"", [Headers=[Accept="application/json", Authorization="Bearer eyJhbGciOiJ..."]]))

How to have the user have access to this parameter on Power BI Service?

Cheers,

Antonio Santos

[mwegener]

Hi @Asantos2020 

look at this.

https://community.powerbi.com/t5/Desktop/PowerBI-Desktop-report-based-on-a-query-with-1-parameter-ho...

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.