Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We are looking to deploy Power BI Reports to our Power BI Report Server with data from an Oracle database. The data is sensitive and needs to remain encrypted right up to the time the user views the reports.
The data in oracle is encrypted and we have no issues accessing that and having it decrypted when querying it into the PB data model. We need to understand if the data is encrypted when it is sitting in the Power BI Report Server after the scheduled refresh and before it is accessed by the end user.
We are not able to find any documentation on this. Any ideas from the community?
PBI Report Server uses SQL Sever for it's data storage. You can either
(1) Use direct query to pull data on demand and without caching from your Oracle DB, which will be supported soon in the next release of PBI RS.
(2) Enable transparant data encryption on the PBI Server's content database.
Perf is hard to say as it depends on your workload. TDE in general notes a 3-5% impact, but only way to be sure would be to measure it with your candidate workload. Note that you can use the provided load test framework to try out your scenarios at https://github.com/Microsoft/Reporting-Services-LoadTest
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |