Forum Discussion
DrPhillip
5 years agoRegular Visitor
Dynamic Database selection from Dashboard/Report
Hi All, I am very new to Power BI and trying to find out if meet our needs. We currently have an on Prenmise SQL Server and have an extensive set of paginated reports built for our analysis. We...
EasyReports
Helper II
12 days agoYou can use a Power Query parameter for the database, but for user selection in the dashboard, a practical option is to combine the five databases into one model with a Database/Company field and let users filter it with a slicer.
For strict data separation, separate models or Row-Level Security may be more suitable.
EasyReports can also help with multi-database reporting by connecting your SQL data and providing centralized dashboards and reports with database-wise analysis.