Forum Discussion
Platform to host power bi reports
Hi again, Dyniel!
Yes, this report I sent to you can be accessed by anyone with the link.
Buuuut...
Yes, theres is a way to create a password to the report:You must create a "New Parameter" (look at the red circle), and set a interval of options, like 9999 for example, then a new table will be created (look at the blue circle):
After that, I created a measure named CHECK where I defined a var named CHECK1 and made a conditional expression to retur the report, if the person set the correct password, or a page with "Incorrect Password" if the password isn't correct. Notice that I defined the password in the fifth line of the code:
For the last I renamed the parameter box to "password". After I created a action for the Submit box where I set the measure CHECK like the Action(red) function(blue) to define to where the page should go acording with the password (correct or incorrect) the people write.
Here's the link of the new report:
The password is: 1848 (write and press enter, after click in Submit)
If you want you can create a large number of logins with different passwords, in this case I created just one named "Ford" to exemplify.
I really hope it helps you. 🤝Regards from Brazil!
Ola! Thank you for this tip however this is not an ideal solution for me. To my understanding, this will always be public so everyone with the link can access the report. Is there an option to create some credentials so only people with the password can see the report?
- HenriqueReis
Resolver I
Hi again, Dyniel!
Yes, this report I sent to you can be accessed by anyone with the link.
Buuuut...
Yes, theres is a way to create a password to the report:You must create a "New Parameter" (look at the red circle), and set a interval of options, like 9999 for example, then a new table will be created (look at the blue circle):
After that, I created a measure named CHECK where I defined a var named CHECK1 and made a conditional expression to retur the report, if the person set the correct password, or a page with "Incorrect Password" if the password isn't correct. Notice that I defined the password in the fifth line of the code:
For the last I renamed the parameter box to "password". After I created a action for the Submit box where I set the measure CHECK like the Action(red) function(blue) to define to where the page should go acording with the password (correct or incorrect) the people write.
Here's the link of the new report:
The password is: 1848 (write and press enter, after click in Submit)
If you want you can create a large number of logins with different passwords, in this case I created just one named "Ford" to exemplify.
I really hope it helps you. 🤝Regards from Brazil!
Hi, this is fantastic however I can't make this submit button work. Any ideas?
Much appreciate your help!
- HenriqueReis
Hello again, haha!
The bottom "Submit" is not going to work because it is not a bottom, it is just a box to write.
We need to create a bottom (because with bottoms we can create actions):Then, put exactly on top of the box "Submit". This way the people are going to see "Submit" but when they click on it they are clicking on the bottom we put on.
Afterward, we enable the option named "action", we select "Page Navigation" type, and we select the "fx" to set a function:
Inside the function, select your measure, then click OK:
Any doubts, I am available.
If it works, consider give me a like and the "✅solution".
Regards from BR!! 😉