Forum Discussion

HoracioNeri's avatar
HoracioNeri
New Member
5 years ago
Solved

How to save data in BD based on selected values in matrix?

Hello everyone,   I am develping a report where I have a matrix that presents a certain metric for each intersection of clusters of demand and clusters of consumers.   The goal is that the user ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi HoracioNeri 

    Not very sure about the meaning of "sends this information to an Azure SQL DB", if you want to create information in Azure SQL DB, it's impossible as far as I known,

    but if you just want to do calculations according to the value selected, you can create measure to get the selected value and show the measure with visual. and in measure you also can do mathematical operation on the selected value.

     

    Best Regards,

    Community Support Team _ Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

HoracioNeri's avatar
HoracioNeri
New Member
5 years ago

Thank you very much for your answer ibarrau. It is very insightful.

 

Would it be possible for PowerApps (inside PowerBI) to read which intersections of the matrix are selected by the user?

From what I understood this wouldn't be possible, but I might be wrong.

 

Best regards,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
5 years ago

No. The PowerApp can't read what is in the page outside it. If the user want to add data they have to navigate through the app and enter data in there.
If all of this is a must maybe there is something you can do with Embed options. I'm not a power bi embedding expert in order to know if you can get the matrix data with javascript or something like that. I would say no, but again I'm not sure.

Regards,