Forum Discussion
Object level security - Paginated Report (missing column)
Hi, we implemented Object level security on PowerBI dataset (February release) and it is working perfectly in PowerBI service and Analyze in Excel. Users can see only columns and tables they are ...
AbhiSSRS
Solution Sage
Solution SageHi Petra! Please pass only the field as the argument is field type
ByVal dataElement as Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field
so the code call has to be : =code.GetValue(Fields!Val_Opening_Balance_Amt). This works
Hi Abhinav,
thanks for the info and all the help, now report is working for me as I am in the Role without OLS restrictions but users under different roles are getting same error:
Could not connect to the data source.
"There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. Query (14, 84) The value for 'Val Stock Net Movement Amt' cannot be determined. Either the column doesn't exist, or there is no current row for this column.".
"There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. Query (14, 84) The value for 'Val Stock Net Movement Amt' cannot be determined. Either the column doesn't exist, or there is no current row for this column.".
From the error I see that probably it fails on the PowerBI Dataset as I am querieng it with DAX in Paginated Report. That is why I think I need to do something on the DAX code itself to catch an error. I am greatfull for you answers as this code will be usefull in other scenarios.
Petra