Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have an issue that our PBI file works fine but when row level security is turned on we get error messages.
We have tracked it down to a caculate measure. When row level security is off this measure works fine -
CALCULATE (sum(UnitSalesValues[Sale Values]), 'UnitSalesValues'[Attribute]= "Sold prior to qtr" )
When row level security is turned on this measure creates the following error is the visual. If the bolded part is taken out the measure works fine.
Colukn't load the data for the visal
An unexpected exception occured.
This same file was working with last months version of PBI. The data in UnitSalesValues is visable with the row level security turned on and has values for "sold prior to qtr".
However, even if we use last months pbix file it does not work in the PBI Embeded enviroment.
This certainly seems to be an error in PBI. Further when the row level security is first turned on a black screen apears and the following program is run.
c:\Program Files\Microsoft Power BI Desktop\bin\SQLDUMPER.EXE
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.