6/11/2023 0 Comments Passwordbox microsoft edge![]() Then reference that query and remove the User column to just give you a password table This is how we initially set up the User and Password table. Navigation through the “hidden” part of the report is then driven by buttons and bookmarks. The first text filter requires the user’s name and the 2nd requires their password.Īfter entering the correct user name and password a single button appears (actually it’s a pie chart with the number 1 as a value) which enables the user to then drill-through to the main report ![]() The Text boxes are actually the Text Filter custom visual from the marketplace (click the Show Passwords button to see the user names and passwords to try out)Īfter clicking the login button 2 Text boxes are shown We’ve published the report for you to try it out: Power BI Report ![]() This is what the user would see when they open the report Once you can capture a name and password you can give access to otherwise hidden pages or even set certain measures to zero by multiplying by zero if the password isn’t correct. To play around with the finished report and see how it works download here. This is not to be used as a substitute for proper security. We have no idea if there are ways to hack this but it’s just an interesting exercise in using some features in Power BI. Here’s a process that allows you to add a password input box to your Power BI report.ĭO NOT, REPEAT DO NOT use this for sensitive data. Free Online Financial Modelling Trainingīy Wyn Hopkins Adding a password box to a Power BI report.Solver Corporate Performance Management. ![]()
0 Comments
Leave a Reply. |