self service reporting

2 Topics

How to achieve Adhoc/Self-service reporting capabilities in PowerBI Report Server
Hi, Is there a possibility to execute self-service reporting in the PowerBI Report Server? i.e. the business wants to create/execute reports via Browser in the PowerBI Report Server Edition. The Business users want to visualize the published datasets via browser without needing to have the Desktop RS installed. I would appreciate it if anyone could share with us the possibilities of achieving the Adhoc/Self-service reporting capabilities. Thanks, Kiran Kumar S
kirankumars
2 years ago Place Report Server
786Views
0likes
1Comment
Preventing hostile self service reporting on privacy sensitive data
The root problem I have is to provide self service reporting on privacy sensitive data and prevent hostile attempts to breech privacy by filtering. The data set has low amounts of data which would make report complately useless if distributions does not show small amounts. My aim is to show small amounts only as part of distribution which is big enough and as reporting is self service, the problem need to be addressed at measure, not at the report. Basically what I need is to hide all data that would have row total or column total at visual less than limit constant in case data is not hidden. And that recardless of axis and filter chosen at report. I would start the idea from something like: my_protected_measure = VAR unprotected_measure = ... VAR column_total = CALCULATE( unprotected_measure, REMOVEFILTERS(current visual row dimension) ) VAR row_total = CALCULATE( unprotected_measure, REMOVEFILTERS(current visual column dimension) ) RETURN IF(AND(row_total >= 5, column_total >= 5), unprotected_measure, BLANK()) How can I refer to current visual row and column dimensions at the measure? If that is not possible, is there some out-of-the-box solution for handling privacy data at self service reporting?
Solved
JarmoAhosola
3 years ago Place DAX Commands and Tips
466Views
0likes
1Comment