Forum Discussion

mcaraballo's avatar
mcaraballo
Advocate III
4 years ago
Solved

How to decrypt gateway credentials

Hi everyone!   Based on the DirectQuery for Power BI datasets and Azure Analysis Services functionality that was introduced in the October 2021 release, I am having a problem in the power bi servic...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi mcaraballo ,

     

    The credentials you need to enter for this SSAS data source should be the SSAS Instance administrator (note that it needs to be a domain account).

     

     

    This phrase means that:

    "The credentials are encrypted using the key stored on-premises on the gateway server".

    When a user enters data source credentials in the Power BI service UI, the credentials are encrypted with the public key in the browser. The gateway decrypts the credentials using the RSA private key, then the gateway will use your credentials to connect to the data source to query the data. And re-encrypts them with an AES symmetric key before the data is stored in the Power BI service. With this process, the Power BI service never has access to the unencrypted data.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi mcaraballo ,

 

The credentials you need to enter for this SSAS data source should be the SSAS Instance administrator (note that it needs to be a domain account).

 

 

This phrase means that:

"The credentials are encrypted using the key stored on-premises on the gateway server".

When a user enters data source credentials in the Power BI service UI, the credentials are encrypted with the public key in the browser. The gateway decrypts the credentials using the RSA private key, then the gateway will use your credentials to connect to the data source to query the data. And re-encrypts them with an AES symmetric key before the data is stored in the Power BI service. With this process, the Power BI service never has access to the unencrypted data.

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.