Forum Discussion
PowerBI Questions Data limit and restriction
What is the Power BI row limit or maximum? Where can I find more information regarding data that can be loaded into PowerBI? How can PowerBI data be restricted to only certain group of people and not be accessible to anyone else?
The row limit can differ based off of certain conditions like using direct query or importing the data. Here is a link to more information: https://learn.microsoft.com/en-us/power-bi/connect-data/service-get-data#considerations-and-limitations
With Power Bi you can create a Workspace and only grant certain people access to it in order to restrict who can see your published reports/ dashboards. If you need to create one report or dashboard that will alter permissions depending on who is viewing the report, you can set up static or dynamic RLS.
Here are some resources for setting up row level security: https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance
Dynamic One-to-Many RLS: https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
Dynamic Many-to-Many RLS: https://radacad.com/dynamic-row-level-security-in-power-bi-with-organizational-hierarchy-and-multiple-positions-in-many-to-many-relationship-part-1
1 Reply
srpetersHelper II
The row limit can differ based off of certain conditions like using direct query or importing the data. Here is a link to more information: https://learn.microsoft.com/en-us/power-bi/connect-data/service-get-data#considerations-and-limitations
With Power Bi you can create a Workspace and only grant certain people access to it in order to restrict who can see your published reports/ dashboards. If you need to create one report or dashboard that will alter permissions depending on who is viewing the report, you can set up static or dynamic RLS.
Here are some resources for setting up row level security: https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance
Dynamic One-to-Many RLS: https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
Dynamic Many-to-Many RLS: https://radacad.com/dynamic-row-level-security-in-power-bi-with-organizational-hierarchy-and-multiple-positions-in-many-to-many-relationship-part-1