I have a question on Row Level Security.
I created a Power BI report for our CEO showing him Sales & Profit data for years 2015 to present. On my first attempt to visualize the data everything worked as expected - the CEO can see all the data and the managers can see only their division. So it works fine.
I received new data that I imported into the data model and it is all fine and correct in the Desktop. The Row Level security works when I test the roles for the managers and the CEO.
When the CEO tries to view the data all the visuals are blank with a statement that they don’t have access to the report, although they do and it tests fine.
I’ve viewed all of Sam’s material on this subject and quite a few more from other Power BI Gurus out there and everything seems setup correctly.
Thoughts on where I went off?? Do I have to re-share the report??
I cannot share any pbix as the data is extremely sensitive.