Forum Discussion
Encrypt parameters in Power Query
Is there any possibility to hide (encrypt) the parameter value in Power Query? Users have to fill in two parameters (username and password) to log into the API and access the report. However, when th...
One option might be to have the parameter contain a filepath to a file that contains their credentials that only they have access to (e.g., on their OneDrive). That way, if someone else gets their pbix, they would only see the path to the file (that they don't have access to).
Of course the other option would be to leverage row level security to limit what people can see.
Regards,
Pat
Hi mahoneypat, thanks for your response. I am relatively new to Power BI, so I would need a web page that explains how to do the two options you mention. If you have any I would appreciate it.
Regards,
Miguel Angel