Forum Discussion

ChristianR's avatar
ChristianR
Frequent Visitor
5 years ago

Oracle - 2 queries in 1 dataset for setting decryption key

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   ...
Data Protection
Need Help
ChristianR's avatar
ChristianR
Frequent Visitor
5 years ago

This wouldn't work for the decryption piece.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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