Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
I am trying to create a report and publish across all production operator their daily output(on mobile view)
But i want the report to function in this way, a seceret password is shared to them, so when they type the password on search they get to see the daily output quantity about them alone.
is it possible to do such thing in BI report?
Data table
Password
1)ideally the report should display blank data
2. each operator was given a secret password , and they will enter in search filter their own password and can able to see their data alone.
in the below case operator = vin, password = 2
operator=mar, passwoed = 5
the challenges for me are, i donot know how to make the initial data table emply, and how to make a search column or search filter where you can only enter data and wont see any hint text/number or all available password from data table.
it would be very helpful if someone can help me with this, or you can also recommend me someother way so i can reach the same conclusion.
the plan is to give some kind of seceret number to each operator which only they know, they go to shared report of power bi in their mobile and type their own password in the search and get to see only their data. and the initial data table should be empty in the start and search filter should not show any hint password of all possible data password available from the password table.
any help is appreciated.
Solved! Go to Solution.
Hi @Anonymous
Brilliant idea! And I've just found a way to implement this!
Seems to be working! Let me know if you see any flaws.
Passwords for testing: power and dserw
1) Install Text Filter slicer:
2) Two measures used:
Hi @Anonymous
Brilliant idea! And I've just found a way to implement this!
Seems to be working! Let me know if you see any flaws.
Passwords for testing: power and dserw
1) Install Text Filter slicer:
2) Two measures used:
Hi! It would be a great solution if Text Filter (or any other visual in Power BI) didn't have this "Show as a table" option when right-clicked on the visual. It seems that you cannot turn this option off.
If you store the passwords like this anyone could see them:
I was trying to figure out another option for free-text input and then pass it to this filter, but couldn't find anything yet 😕
Thank you @Anonymous for testing my method. I've found a workaround for the critical issue you have found. Categorize password column as "Image URL".
And one more idea is here!
Cover your headers with a white card that shows empty string.
Use this measure
Important Update
Duplicate every row of your passwords table (using Power Query). Replace last character of each duplicate password with "_" and add "_" to each duplicate user name. Add 'Real User' column with 1 for original rows and 0 for duplicate rows.
Update measures. Instead of HASONEFILTER( Passwords[password] ) use this variable:
If I type "wer" I have access
@VictorLozovik
Thanks for your comment. Easy to fix by adding one more set of duplicate records to Passwords table. With "_" instead of first character of a password. In this case 'wer' or 'ower' wont' open the data.
Here you will find sample .pbix file and updated description http://powerofbi.org/index.php/2020/06/12/simple-authorization-based-on-visuals-and-dax-measures/
Hi all & @avatorl ,
I wa working on similar thing and got stuck here.
How can i hide this table and display only the choosen result of searched order no through search filter?
I want to hide this table with a card and be visible only when an order no is searched.
But donot know what formula to use and how to proceed.
Any help is highly appreciated.
@Anonymous
sorry for the dealy, I've missed your question. I hope you already solved the problem. You can follow my instructions doesn't matter it's a password or order number. You just need to create duplicates with leadning and edning "_" to make sure partial password (order number) doesn't trigger value selection in the filter.
My general question is, "is there a way to have a sequrity roles for someone who doesnot have power bi or microsoft account, but just have access to published PBIX link", so they can enter some kind of password in the search column or in a text box and it will show only their data.
This is my whole idea behind my question on the post.
Thanks in advance. Any suggestion is welcome.
Proud to be a Super User!
Ja, maybe so. i will check the possibilities. Thanks.
Proud to be a Super User!
Hi @vanessafvg,
Thanks for suggestion. I will use this idea in sharing the report with people who has microsoft user account, but for now i am sharing the power bi publish link to production operator, as they donot have microsoft account, they will just use the PBI publish link i send them to view their output. I am looking for a solution how i can create a solution/ provide security or a password kind of thingy for someone who doesnot have microsoft / power bi account but will be simply using the published link.
Thanks for help.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
33 | |
16 | |
12 | |
11 | |
9 |
User | Count |
---|---|
44 | |
24 | |
16 | |
14 | |
14 |