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.
I am trying to executive a stored procedure which executes another stored procedure to decrypt some data. I get the unecrypted data but all the encrpyted data is blank. I have made sure both SP's have the Execute permission using the account used in the Gateway credentials along with the service account the gateway service is running. And when the Scheduled Refresh happens there is no errors.
Hi @jeffprandall ,
You can refer to the related blogs and documents provided below, hoping to help you.
Always Encrypted - SQL Server | Microsoft Docs
Power BI and SQL Always Encrypted (linkedin.com)
If the problem is still not resolved, please provide detailed error information screenshoot and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The database itself is not encrypted just the data in the column. The stored procedure makes a OPEN SYMMETRIC KEY and DECRYPTION BY CERTIFICATE to unencrypt the data.
Hi @jeffprandall ,
Is your problem solved, do you need further help? Looking forward to your reply.
If the problem has been solved, you can mark the valuable reply as the correct answer to help the other members find it more quickly.
Best Regards,
Henry
No it still does not work.
Permissions ran - top user is the service account, bottom user is a SQL Account used in Gateway Credentials (tests do pass)
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 |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |