Hey guys,
I am new to PBI and hope that I did not miss an existing thread about the following topic.
Our situation: We have a table with let's say username and ages. I want to filter this table on a certain age. With the filtered list of users, an API shall be dynamically called. The API will return a single numeric value for the list of users. Besides, the API won't officially be supported by PBI. Right now the API is called via an empty query and a Web.Contents statement like this:
let
url = "http://127.0.0.1:8080/reviews/",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([review_ts = _review_ts, name = _name]),
response = Web.Contents(
url,
[
Headers = headers,
Content = postData
]
),
jsonResponse = Json.Document(response)
in
jsonResponse
My problem is that I can not figure out how to pass the filtered table (or list) to _name so it gets used in the query. We need our end-users to filter the table from the Dashboard. The problem with this is that if I understood it correctly, I can not make use of Dynamic M queries to , because this is no Direct Query.
Question: How would you solve this issue? Is there a way to convert it to a Direct Query? I also tried realizing this with a Python script but in order to formulate the POST request, I need a Python package that is difficult to enable on the PBI service (security reasons). Oh yeah, I almost forgot: In the end this report shall run on the PBI service
I would appreciate your helpful guidance 🙂
