How to get user inputs to call a service API?

[kmouneca]

Hi Team,

Requirement: Trying to get date parameters from the user and to pass it dynamically to the API.

I have tried the below two approaches,
1. Using DAX function
2. Using M Function

DAX -> https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
M Func -> https://www.mssqltips.com/sqlservertip/6756/power-bi-calendar-table/

I have used the above articles as reference. But in both of the approaches, I got stuck while assigning "bind to parameter" as I could't see that option available for the column I've created. Not sure if I'm doing somthing wrong here.

Could someone please help me find the root cause?

Screenshot

[lbendlin]

Bind to parameter only works for Direct Query data sources. Your API call is not considered a Direct Query data source  (although technically you could argue that it is one).

Another alternative would be to (ab)use an R or Python visual.