Forum Discussion
Encrypt the Query String Parameter value in the Power BI URL
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.
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.
9 Replies
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 lbendlin ,
Thanks for yor replay
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.
