Forum Discussion
Rahulsingh
10 years agoHelper I
How to connect multiple database with same table in Power BI
Hi Everyone I have a unique situation where my client has 23 databases for their companies with same table and views. they want a report in which they can filter the report by each company and vi...
- 10 years ago
Hi Ankit,
Is it possible to get an example on how to create a database connecion parameter . Thanks
ankitpatira
10 years agoCommunity Champion
Rahulsingh What you want to do is in powerbi desktop create two parameters that contains server and database name for your databases (i am guessing you have sql server database). Then create all your reports from first database in powerbi desktop and save that as powerbi template file (.pbit). Next when you open that template file it will ask you for values for those parameters and you can enter in that for all other databases. By this you won't have to create seperate pbix for each database and you can use just one template file for all your databases.
Hope it make sense.
Murali_1992
3 years agoNew Member