Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Using Oracle 19c as a data source. I need to set the decryption key for some column on my Oracle session.
In Oracle SQL Developer we typically do these 2 statements separated by Semi Column
This wouldn't work for the decryption piece.
HI @ChristianR,
Do you mean this issue only appears when you add the encryption/decryption parts to advanced queries?
If that's the case, you can trace the connection sessions on the database side to confirm if they have enough permissions to execute or have been blocked by power bi itself. (some functions or features will be limit use when you use with the data connector due to security reasons)
Regards,
Xiaoxin Sheng
HI @ChristianR,
I'd like to suggest you mix them into one query, power bi seems not support invoke multiple SQL statements at the same time.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |