PowerBI with Database Isolation

[MickCollum]

Hi there.  I'm looking at implementing PowerBI into our application, and have got 'App owns Data' all set up and working correctly. However our customers data is all in separate databases for isolation.  How would I achieve connecting to these without having multiple copies of the same report, one for each customer.  To add context, in our SSRS reports we pass the connection string through as a parameter when the report is run - however I can't see a way of acheiving this through PowerBI.  An alternative would be to have an equivalent of the old SSRS 'Linked Reports' where I have one master copy of a report and then multiple off shoots where I can set any parameters, data sources, etc.

Our set up is PowerBI embedded for customers, with App owns data, and using an on prem gateway for the connections.

Any help or guidance would be much appreciated.

Thanks

[v-zhangti]

Hi, @MickCollum 

Please refer to the following links in the hopes of helping you.

Understanding the different embedding solutions in Power BI embedded analytics | Microsoft Learn

Embed content in your Power BI embedded analytics application - Power BI | Microsoft Learn

Migrate SQL Server Reporting Services reports to Power BI - Power BI | Microsoft Learn

Solved: How to migrate SSRS reports to Power BI and create... - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.