Forum Discussion
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 can look at the matrix and decide which intersections he would like to pursue for the next 5 years, in same cases the user should be able to create groups of two or three intersections.
I would like to allow the user to create this 'areas-to-pursue' by selecting the intersections in the matrix and clicking in a button that reads the selected intersections and sends this information to an Azure SQL DB.
Is this possible to do?
Best regards,
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.
5 Replies
- ibarrau
Super User
Hi. This is not possible. Power Bi is a tool that only reads data. You can make it insert from a user interaction. By default this would be impossible.
However I remember watching a company that has develop a Custom Visual and a Client (that has to be installed in the VM of the BD) that together would let the user insert somehow. That doesn't mean it's what you are looking for. I strongly suggest you to avoid going throgh that path.
If you need to insert data you can use another tool like PowerApps, Power Automate, build a custom app, load and excel in drive or something like that. In addition, remember you can add a PowerApp inside a Power Bi Report. That would be the most close you can go on the path of inserting data.
I hope that helps,
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
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,
v-xiaotangCommunity Support
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.
Thank you v-xiaotang,
Your message was very helpful and straightforward.
Best regards,
