Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
NPatel12498
Frequent Visitor

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?

1 ACCEPTED SOLUTION
srpeters
Helper II
Helper 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-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...

 

View solution in original post

1 REPLY 1
srpeters
Helper II
Helper 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-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...

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors