jeudi 4 mars 2021

set time range to web api in PowerBi

I'm getting data to PowerBi using WebAPI. Currently, I locally set up the data(excel file) and after preprocessing the data(using pycharm). In API, set the parameter I want,

ex: http://localhost:5789/uow/analysis/management?category=MachineTypeA&section=all&time=range&startTime=1608255000&endTime=1610933400

here i set the machine type and hardcoded the startTime and endTime. What I want to do is, instead of hardcoding the startTime and endTime, i need to set the time in powerBi visual side using the date slicer. after getting time from the date slicer, API preprocessed the data and visualize the output according to the given time.

Is this possible in powerBi? i read the powerBi community questions but didn't find the related answer.

Really appreciate your support !!!!!!!!!!!




Aucun commentaire:

Enregistrer un commentaire