Forum Discussion

Quentin_'s avatar
Quentin_
Icon for Helper I rankHelper I
3 years ago

Api call dynamic date determine by the user

Hello,   I don't know if this is possible in PowerBi but I would like generate an API call based on the selected period in my "Calendar" filter. If the selected period changes, the API call should...
Need Help
Tips and Tricks
Quentin_'s avatar
Quentin_
Icon for Helper I rankHelper I
3 years ago

Hello cpwebb 

Thank you for your reply.
I must have a table based on the selection calendar because if I request all my API I will have data day by day. 

Exemple :

 

DatevisitsBounce rate
01/01/202310000,5
02/01/202350000,3
.........
11/07/202313000,4


 It's not a problem if I create a measure to calculate "visits" column but my calcul will be wrong if I apply a measure on bounce rate column because the result of API is already an average. If I create a measure I will apply an average to another average :s

It's the reason why I must refresh my api call based on the user selection period.

 

Thank you 🙂

cpwebb's avatar
cpwebb
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

OK, well as I said you won't be able to do this with Power BI - your only option will be to get the raw data and recreate all the calculations in a measure.

  • Quentin_'s avatar
    Quentin_
    Icon for Helper I rankHelper I
    3 years ago

    Thank you cpwebb 
    I will see how manipulate these data and maybe this feature will be available in the future Power Bi versions 🙂