Add Report Level Security Model

The application needs to be upgraded to support a security model with the following features:

[ ] Must allow for various AAD groups to be granted or denied access to each report
[ ] This should be added to the model contained in the structure of the "reports" section of the appsettings.json
[ ] Security model should map users to an "effectiveuser". Effectiveuser will be passed through to PowerBi and used in Row Level Security.

Current "Report" model in appsettings.json:

"Reports": [{
                "UniqueId": 1,
                "DisplayLevel": 1,
                "DisplayName": "Offenders Report",
                "WorkspaceId": "{SampleWorkSpaceId}",
                "Description": "This is the offender report",
                "ReportId": "{SampleReportId1}",
                "DrillThroughReports": [2],
                "RequiredParameters": [],
                "PaginationTable": "",
                "PaginationColumn": ""
            },
            {
                "UniqueId": 2,
                "DisplayLevel": 2,
                "DisplayName": "Offender PII Report",
                "WorkspaceId": "{SampleWorkSpaceId}",
                "ReportId": "{SampleReportId2}",
                "Description": "This is the offender PII report",
                "DrillThroughReports": [],
                "RequiredParameters": ["OffenderId"]
            },
            {
                "UniqueId": 3,
                "DisplayLevel": 1,
                "DisplayName": "Offenders Report 2",
                "WorkspaceId": "{SampleWorkSpaceId}",
                "Description": "This is the offender report",
                "ReportId": "{SampleReportId1}",
                "DrillThroughReports": [2],
                "PaginationTable": "",
                "PaginationColumn": ""
            },
            {
                "UniqueId": 3,
                "DisplayLevel": 1,
                "DisplayName": "Offenders Report 3",
                "WorkspaceId": "{SampleWorkSpaceId}",
                "Description": "This is the offender report",
                "ReportId": "{SampleReportId1}",
                "DrillThroughReports": [2],
                "PaginationTable": "",
                "PaginationColumn": ""
            }
        ]

microsoft / powerbi-data-access-auditing

Add Report Level Security Model #9