Forum Discussion
save drop down selection to datasource
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?
2 Replies
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/
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?
