Forum Discussion
Integration of embedded dashboard with multiple datasets
Hi everyone, I have a case where I want to select up to 10 data sources in my web application, pass their source paths (or any other relevant information about connection) and then use these data so...
Thanks for the reply! Could you elaborate a little bit more on that?
As far as I know there is possibility to dynamically change connection, for example by using parameters when connecting to SQL Server, so I assume that it is one way of doing that inside PBI.
You suggest that I would have to bring all of the data into Power BI (and Power BI Report server later) or use live connection but preconnect to all tables, and then only choose what data should be shown using e.g. RLS?
lbendlin
Super User
Super UserI think you are referring to this Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs - note that the feature is still in preview and may or may not cover your type of data source.