Forum Discussion
one dashboard for multi users and multi databases of the same schema
hi :) I have 9 databases with the same schema for 9 clients that all sign in my web applicaiton and every one see his data by a reports build by me in asp.net Now after I see power BI I wonde...
Thanks for the clarification and the links.
actually putting all data in one Databases can not be done for now and the number of databases may increases in the future.
so can I create a Data-set for each Database, then when user connect I just connect the dashboard to that data-set to view his/here data?
Just chiming in. How granular is the data that it can't be consolidated into one database? Also if it's very granular how about aggregating it? You're gonna have to do some sort of aggregation in power BI anyway. As the previous person said, you can then add in RLS to filter the data for specific users. It's probably even much more managebale and better architecture this way tbh.