topic Re: Is it possible to integrate to Hashicorp Vault? in Report Server

Is it possible to integrate to Hashicorp Vault?

FMohara — Wed, 19 Jul 2023 21:11:03 GMT

Simple question, is it possible to integration Power BI Reporting Server with my company local hashicorp vault instance to manage secrets, like the passwords for the connection strings?

If so, how is it done?

If it's a customization, where can I get help from?

I wish to install the tool in an on-premises environment, where we need to connect to the vault to manage secrets.

Or is it possible to recover the password string from a variable in the memory of the application? (I would then create a separate powershell script to populate that variable calling the vault)

Any help will be much appreciated.

Re: Is it possible to integrate to Hashicorp Vault?

d_gosbell — Thu, 20 Jul 2023 00:05:23 GMT

FMohara wrote:

Or is it possible to recover the password string from a variable in the memory of the application? (I would then create a separate powershell script to populate that variable calling the vault)

It should not be possible to recover any passwords from the server. But if you are just looking to populate them using a script there are REST endpoints like the following one for PBIX reports PBIRS | 2.0 | microsoft-rs | SwaggerHub which will allow you to set the credentials for a give data source

Re: Is it possible to integrate to Hashicorp Vault?

FMohara — Thu, 20 Jul 2023 15:13:01 GMT

Thank you so much.

Didn't test yet, but the PUT /datasource({id}) might work for me.
Get a script to call the vault and then call this api to update the datasource.

Should work just fine.

Re: Is it possible to integrate to Hashicorp Vault?

d_gosbell — Thu, 20 Jul 2023 22:31:37 GMT

I have not tested either, but I think possibly doing a GET then adding credentials and doing a PATCH request might work.