Prerequisites and impact of enabling "Encrypt" in Report Server Database Configuration
Hello everyone, I am currently configuring my Power BI Report Server. In the Report Server Configuration Manager > Change Database wizard, there is an "Encrypt" checkbox for the database connection (as shown in the attached screenshot). I would like to ask: 1. What are the exact prerequisites on the SQL Server side to enable this successfully? 2. Will enabling it cause any downtime or connection issues if not configured perfectly? 3. Does it require a specific SSL/TLS certificate setup on the Database Engine? Any advice or official documentation links would be highly appreciated. Thank you!
Encryption
Hi all, I have a doubt related to encrytion. In my company they want to encrypt some sensitive information columns, we have different databases but we created pipelines and all the information is in BigQuery, so some sensitive information columns will be encrypted in BigQuery. In my report, we use some sensitive columns in measures or relationships, my question is what are the good practices in Power Bi? I mean, should I still use this encrypt information in the measures and everything like it was or what? it is the first time so I am a bit lost. Also if for use some of them in the filters, can I decrypt it?
