Encrypt the Query String Parameter value in the Power BI URL

[kishore7rk]

In my scenario, I need to navigate to a Power BI report from other Power BI Report, there I can make use Link/Button with Web URL option and can set this URL.  But while passing any values for a parmeters/fields, is there a way we can encrypt the values and pass?

Example: in below URL the Territory value NC passing in URL can be encrypted?

Example 2:  in below Executive field value  'Andrew Ma' can be encrypted?

Microscoft Documentation on Query String Parameters in the URL: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters.  But I have not seen any option to Encryipt the parameter values passing in the URL.

[v-kpoloju-msft]

Hi @kishore7rk,

Thank you for reaching out to the Microsoft Fabric Community Forum.

We really apologies for the inconvenience, after reviewing the issue of encrypt the query string parameter value in the power bi url, here are few steps to may resolve the issue.

Power bi does not natively support encrypting query string parameters in url’s. However, you can implement encryption using a custom approach.

• You can implement custom encryption and decryption logic using power bi's power query language or dax. Encrypt the parameter values before passing them in the url and decrypt them within the report.
• For instance, apply a simple encryption algorithm in power query to secure the values and a corresponding decryption algorithm in the target report to decode them.
• Instead of directly passing sensitive data in the url, utilize a secure web service for encryption and decryption.
• The url can include a token or identifier that the web service uses to securely retrieve the actual parameter values securely.
• If embedding power bi reports in a web application, manage the encryption and decryption within the application code.
• The application can generate secure url’s with encrypted parameters and decrypt them before rendering the report.

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

Thank you.

[v-kpoloju-msft]

Hi @kishore7rk,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[kishore7rk]

Hi @v-kpoloju-msft ,
Thanks for your details explanation and approach.
This looks a workaround, but we do not have any API or function to encrypt or Decrypt at M-Query leavel.  So as of now we are continuing with Drill through approach.

[v-kpoloju-msft]

Hi @kishore7rk,

Thank you for the detailed information provided.

Please try the following workarounds to resolve your issue:

• Instead of directly passing sensitive data in the URL, use a secure web service for encryption and decryption. The URL can include a token or identifier that the web service uses to securely retrieve the actual parameter values.
• When embedding power bi reports in a web application, handle the encryption and decryption within the application code. The application can generate secure URLs with encrypted parameters and decrypt them before rendering the report.

If this post helps, please give us Kudos and consider accepting it as a solution to help other members find it more quickly.

Thank you.

[lbendlin]

Not currently supported.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[kishore7rk]

HI @lbendlin ,
Thanks for yor replay