Forum Discussion
TheracPowBi
4 years agoFrequent Visitor
Use filters after user connection with PowerBi
Hi everybody, I have an ASP.NET app in C#. When I launch it, a website is opened with a login page. I want that, when a user enter his username and password and click on the "connection" Button", ...
TheracPowBi
4 years agoFrequent Visitor
Hi Hasham,
thanks for your answer.
I used the row-level security and when I arrived on the page to manage the roles, in the table filter DAX expression, I used the USERNAME() format. But does it mean that it will filter on the user currently connected to PowerBI ?
In my case, I have a database on SQL server with all the users, but they don't have a PowerBi account.
When the users will connect in my website, I will just verify if they are real users when they enter their username in a TextBox, and then verifying if this user exist in my database.
So, is this possible to use the filter with the username that the user wrote in the TextBox ?
Thanks.