Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Passing slicer value as a parameter to API

Hi All, We are trying to call an API and get some data into Power BI. We will be using the "Web" option from Get Data and this API will accept one parameter, which is productID. The way this should work is users will select a ProductID from a slicer and then this "selected" value should be passed dynamically to the API end point(URL).

 

My question is how can I pass the selected value from the slicer to the URL.

 

I am thinking we can set a parameter in the Power Query and some how pass the selected value to the paramter and then the underlying API url uses this parameter value.

 

Something on these lines:

= Json.Document(Web.Contents("https://openlibrary.org/api/books?bibkeys=ISBN:" & parmSelectedISBN & "&format=json"))

 

But I really don't know how to pass the user selected slicer value to this parameter.

 

Any help or guidance on this use case is very much appreciated.

 

Thanks,

Aman

  • Not possible.  Dynamic M Query parameters only work with Direct Query data sources.

2 Replies

  • Not possible.  Dynamic M Query parameters only work with Direct Query data sources.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for your response lbendlin. Too bad we can't handle this type of use case in Power BI.