Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
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-limitati...
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-multipl...
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-limitati...
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-multipl...