Integration of embedded dashboard with multiple datasets

[Anonymous]

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 sources to make visualisations in PBI. The data is stored on azure data lake where I have multiple files to choose from. 

Is such thing achievable with embedded analytics? I am new to embedding and such scenario sounds a little bit complicated for me but its sounds feasible. Maybe with binding datasets? Thanks in advance for all the support.

[lbendlin]

You would have to cheat and pre-connect to all these data sources. Then in the UI you can decide which of these to show to which users.

Power BI does not allow to switch data sources on the fly, at least not officially.

[Anonymous]

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]

I 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.