Permission denied on calculation item... because it references a secured object

[Kaycee]

I've just introduced a calculated item to conditionally format data in a visual in Power BI using Tabular Editor.

The first user to be granted access to the new report set cannot see the data in the report as a result of an error "Permission denied on calculation item 'x' because it references a secured object".

It works fine for those with admin access.

To my knowledge, only RLS has been applied (no OLS - certainly not intentionally).

This user has access to everything and as such their role in RLS has no conditions set. The Role is blank against every table therefore implicitly allowing access to everything.

Until now, this has worked perfectly.  I am unsure where to start looking - as far as I can tell, full access is granted to the user. They are view the report via an app.  Would appreciate any guidance on what to check in this instance.

[amitchandak]

@Kaycee , that sounds strange. A better Idea would be to note role details. Delete and create again

[Kaycee]

Thanks @amitchandak for taking the time to reply.

I have cleared all security (ie. no RLS).  The report worked.

I added a row called "Full Access" which had no conditions.  Added the users to the RLS Row, and now the same error appears. 

I was just exploring and noticed the items shown in yellow against a relevant table. As far as I can see all the tables look the same as this but I wonder if it is realted...???

[amitchandak]

@Kaycee , Are you creating roles in Tabular Editor or Power BI? If you creating in Tabular editor, then remove and create in power bi.

Or give what exactly you are doing, and I will try that

[Kaycee]

@amitchandak, 

I was creating roles in Power BI.  Wasn't aware you could do it in Tabular Editor.

I just went to 
--> Modelling
--> Manage Roles
--> Create
--> Named the role "Full Access"
--> Save (ie. didn't put any restrictions anywhere). 

In Tabular editor, I have a calculation group with 1 calculation item.  Let's call it "Formatting".  In that calculation item the expression is SELECTEDMEASURE(). 

The Format String Expression is:

IF ( ISSELECTEDMEASURE ( [Sales], [Budget], [Variance]), MAX('Reporting_P&L Structure'[Text Format]), SELECTEDMEASUREFORMATSTRING () )

The measures names I've simplified. The [Text Format] column is simply a table which reflects the format I'd like it to use where required. For example #,0 or 0.00%. 

The DAX itself works perfectly fine when no RLS is applied.  But I'm providing it anyway for your reference. 

If you need anything else, pls let me know.