Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am getting data for my report from the below rest API:
http://186.14.7.4:10000/ZA/v1/MH200_B65/GUIAl/Equipment
I am building this sample report on the dataset where a deafult date from and to selected:
Now, my requirement is when user select a date from the slicer then it must take the data directly from the source based on the input parameter "start date" and "end date". This is the manadatory requirement from the client which i have to implement.
I need the any possible soultion by which this can be done. I read from few links that we can pass the date parameters to the URL like
http://186.14.7.4:10000/ZA/v1/MH200_B65/GUIAl/Equipment/request?startdate = " " &&enddate = " "
But i am not able to understand this properly. Please suggest how to achieve this as this is a must for me.
Thanks
Solved! Go to Solution.
Hi , @jitpbi
You can check if the solutions in these related posts help.
https://community.powerbi.com/t5/Power-Query/Rest-API-Dynamic-Date-Query/m-p/956246
Best Regards,
Community Support Team _ Eason
@jitpbi - Not sure it is supported today but it does look like some form of this is coming:
Hi,
I came through a post which suggest the solution something like this:
let
Source = Json.Document(Web.Contents(http://186.14.7.4:10000/ZA/v1/MH200_B65/GUIAl/Equipment?startTime=2020-08-20&endTime=2020-08-21)),
sd = Date.ToText(StartDate,"MM-dd-YYYY"),
ed = Date.ToText(EndDate,"MM-dd-YYYY"),
url = http://186.14.7.4:10000/ZA/v1/MH200_B65/GUIAl/Equipment?startTime= "& sd &" &endTime="& ed &"
in
sd
Please suggest on this.
Thanks
Hi , @jitpbi
You can check if the solutions in these related posts help.
https://community.powerbi.com/t5/Power-Query/Rest-API-Dynamic-Date-Query/m-p/956246
Best Regards,
Community Support Team _ Eason
@jitpbi , I doubt that is possible.
@Greg_Deckler , @parry2k , @ImkeF , Any suggestion on this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |