Forum Discussion
Row Level Security in Excel (Saved on Sharepoint)
Hi telra5118
To my knowledge, Row Level Security cannot be applied to an Excel File.
Row Level Security in Power BI requires that you have at least Power BI Pro license because you need to publish the Power BI report to Power BI Service and share it with your students. For your students, they also need Power BI Pro licenses to see the report shared with them. If you don't need to use Power BI often, this cost should be taken into consideration.
If you store data in a local SQL Server Database and deployment data model to SQL Server Analysis Services, you can implement RLS for free when the data size is not very large. But this requires that you and your students should have local accounts that have access to the on-premises SSAS server or the SQL Server database. This would need to implement on-premises Azure AD to manage your local accounts. IT team needs to get involved. And you may have difficulty accessing the data when outside of your organization's network.
You could try the alternatives provided by bcdobbs. Currently I could not think of any better alternatives.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.