Request 027

model Model
	culture: en-US
	defaultPowerBIDataSourceVersion: powerBI_V3

/// Generated by Migration Workbench from family F193 (Request 027); replaces 1 source reports.

table Incident
	lineageTag: f193-incident

	column Agency Id
		dataType: int64
		sourceColumn: agency_id
		summarizeBy: none

	column Cleared
		dataType: int64
		sourceColumn: cleared
		summarizeBy: none

	column Location Type
		dataType: string
		sourceColumn: location_type
		summarizeBy: none

	column Occurred Date
		dataType: dateTime
		sourceColumn: occurred_date
		summarizeBy: none

	column Offense Code
		dataType: string
		sourceColumn: offense_code
		summarizeBy: none

	column Property Loss
		dataType: decimal
		sourceColumn: property_loss
		summarizeBy: none

	column Reported Date
		dataType: dateTime
		sourceColumn: reported_date
		summarizeBy: none

	partition incident = m
		mode: directQuery
		source = Sql.Database("rjdw-sql", "RJDW"){[Schema="dbo",Item="incident"]}[Data]

	measure Incidents = COUNTROWS(Incident)
		formatString: #,0

table OffenseCode
	lineageTag: f193-offense_code

	column Offense Code
		dataType: string
		sourceColumn: offense_code
		summarizeBy: none

	column Offense Desc
		dataType: string
		sourceColumn: offense_desc
		summarizeBy: none

	partition offense_code = m
		mode: directQuery
		source = Sql.Database("rjdw-sql", "RJDW"){[Schema="dbo",Item="offense_code"]}[Data]

table Agency
	lineageTag: f193-agency

	column Agency Id
		dataType: int64
		sourceColumn: agency_id
		summarizeBy: none

	column Agency Name
		dataType: string
		sourceColumn: agency_name
		summarizeBy: none

	partition agency = m
		mode: directQuery
		source = Sql.Database("rjdw-sql", "RJDW"){[Schema="dbo",Item="agency"]}[Data]

table UserAgency
	lineageTag: f193-user_agency

	column Agency Id
		dataType: int64
		sourceColumn: agency_id
		summarizeBy: none

	column User Name
		dataType: string
		sourceColumn: user_name
		summarizeBy: none

	partition user_agency = m
		mode: directQuery
		source = Sql.Database("rjdw-sql", "RJDW"){[Schema="dbo",Item="user_agency"]}[Data]

role 'Agency users'
	modelPermission: read

	tablePermission Agency = [Agency Id] IN CALCULATETABLE(VALUES(UserAgency[Agency Id]), UserAgency[User Name] = USERPRINCIPALNAME())