save drop down selection to datasource

[san-to]

I have a connection to a sql server database and use a view - say vProjects -  as a source for a drop down control. I want to display the project names in the drop down list and save the ID of the selected project in some table - say tSelectedProject - so I can filter other views based on the selection. I used the Slicer visual to build a drop down control that is populated by vProjects but how would I save the ID of the selected project to tSelectedProject? Or how can I bind the drop down control to the datasource?

Does this approach even make sense in Power BI? Should I rather build a view containing all necessary data and then fill all controls/visuals based on this data object and derived objects like lists, so all controls are filtered simultanously based on the build-in filter applied in Power BI by default?

[san-to]

It seems to me like Power BI is more of a data visualization tool than an application builder. It doesn't support a bi-directional communication between the interface and an sql server. I found only one workaround using an R library to pass slicer selections to sql server. Why is it required to use a foreign library to communicate between to Microsoft products?

[amitchandak]

@san-to , You can explore if these can help

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

dynamic M parameters

https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/