Forum Discussion

kmouneca's avatar
kmouneca
Frequent Visitor
3 years ago

How to get user inputs to call a service API?

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

 

Need Help
Tutorial Requests

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    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.