Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Data Model data encryption on Power BI Report Server

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?

4 REPLIES 4
Jon-Heide
Employee
Employee

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. 

Anonymous
Not applicable

Thanks. I have tested out with direct query with our dataset but it has too many limitations for it to work adequately for our situation.
Have you actually done a TDE data encryption on Power Bi report server? We knew it was possible on the regular report server but wanted to be sure it would work on the PBI report server. Any performance impacts form having encryption turned on?
Thanks.

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

Anonymous
Not applicable

Thanks @Jon-Heide. We'll give it a go.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.