I want to store multiple clients' data into a central database. I was wondering if it's possible go give each client their own encryption key and have it all stored in the same database encrypted. Then when a report is ran, PowerBI will decrypt the data using the private key.
Is that possible or is there a best practice for doing this? Like creating a separate database or table for each client but have it all go to the same PowerBI server?