Is there a way to prompt user to enter credentials...

Mohanasudharsan · ‎04-13-2023

We are looking for a solution, where there is a way to prompt users to enter their database credentials to view or edit the published workbooks.

Though Power BI provides a way to implement Row-Level Security based on the below link:

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

However, it doesn't fulfill the requirements completely.

We are looking forward to a solution.

ibarrau · ‎04-13-2023

Hi. By default only direct query can follow security from power bi to the database source for the loged user. However I recently have read an article to keep your database security with imported datasets. I think the only problem is that it needs premium if you want to hide tables from users.

https://data-marc.com/2023/04/12/simplifying-security-replication-in-power-bi-a-step-by-step-guide/

I hope that helps, otherwise you can just limit rows with RLS.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog