Forum Discussion
Encrypt the Query String Parameter value in the Power BI URL
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
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.
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.
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.
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.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.
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.
