Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Get result only from Q&A using Power BI API

Hi,

 

We need to give users the ability to create their own custom measures (called "indicators"). These are non Power BI users. 

 

Before I get into the details, let me give a summary of our requirement:

Using Power BI's Q&A we want to give users the ability to type a question, see the result of the question and save the question as a new indicator, which is then calculated automatically for their business area.

 

Let me break it down:

  1. Ability to type a question: See the Sample Q&A for an idea of what we want to embed. A question can be typed to find a result in the dataset.
  2. See result of the question: We only need to visualise the result as a card to get the current value.
  3. Save the question as a new indicator: Store the interpret result or the DAX formula (assuming that's how it queries the data model) in an indicator library. 
  4. Calculated automatically: Every time the user refreshes his/her indicators, the latest value of the indicator is recalculated and stored in our DB for other uses.


Our entire team of developers looked for a way to get this to work, but it seems the limitations are:

  • The final JSON response of the visual does contain the result, but it is not simply interpretable and lies very deep in the file as there is a lot of "fluff" to visualise the result which is not what we need.
  • The interpret response from the Q&A does not contain a DAX / MDX formula which we can interpret. (i.e. it is only for the API)


We could technically get this to work, but it would be a hack which will probably fail on a future update of Power BI.

 

Any ideas of what we can do?

 

Kind regards,

Rian

No Replies