Feedback Type: Frown (Error) Timestamp: 2017-11-09T09:06:03.2544868Z Local Time: 2017-11-09T09:06:03.2544868+00:00 Session ID: d8670f02-544b-473f-839b-0f7fa4198618 Release: October 2017 Product Version: 2.51.4885.701 (PBIDesktop) (x64) OS Version: Microsoft Windows NT 10.0.15063.0 (x64 en-GB) CLR Version: 4.7 or later [Release Number = 460798] Peak Virtual Memory: 34 GB Private Memory: 313 MB Peak Working Set: 449 MB IE Version: 11.674.15063.0 Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Import Snapshot Trace Logs: C:\Users\Daniel\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot202728966.zip Performance Trace Logs: C:\Users\Daniel\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_EnableReportTheme PBI_numericSlicerEnabled PBI_SpanishLinguisticsEnabled PBI_daxTemplatesEnabled CustomConnectors PBI_reportBookmarks Disabled DirectQuery Options: PBI_DirectQuery_Unrestricted Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI Formulas: section Section1; shared Taxonomy = let Source = SharePoint.Tables(#"Sharepoint GDPR URL", [ApiVersion = 15]), #"e01103da-da9d-4f73-8e07-cab931d246d5" = Source{[Title="TaxonomyHiddenList"]}[Items], #"Renamed Columns" = Table.RenameColumns(#"e01103da-da9d-4f73-8e07-cab931d246d5",{{"ID", "ID.1"}}), #"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns",{"IdForTerm", "Title"}), #"Renamed Columns1" = Table.RenameColumns(#"Removed Other Columns",{{"IdForTerm", "TermId"}, {"Title", "TermName"}}), #"Merged Queries" = Table.NestedJoin(#"Renamed Columns1",{"TermId"},TaxonomyCodes,{"IdForTerm#(lf)IdForTerm"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"TermCode"}, {"TermCode"}) in #"Expanded NewColumn"; shared Events = let Source = SharePoint.Tables(#"Sharepoint GDPR URL", [ApiVersion = 15]), #"4e006c08-c0ab-4f71-b94a-b58fc15578c3" = Source{[Title="Events"]}[Items], #"Extracted First Characters" = Table.TransformColumns(#"4e006c08-c0ab-4f71-b94a-b58fc15578c3", {{"ContentTypeId", each Text.Start(_, 40), type text}}), #"Renamed Columns" = Table.RenameColumns(#"Extracted First Characters",{{"ID", "ID.1"}}), #"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns",{"Id", "ContentTypeId", "Title", "GDPRNotifiedBy", "GDPRReportStartDateTime", "GDPRReportEndDateTime", "GDPRBreachType", "GDPRSeverity", "GDPRDPANotified", "GDPRDPANotificationDate", "GDPREstimatedAffectedDataSubject", "GDPRIncludesChildrenData", "GDPRPlannedRecoveryAction", "GDPRBreachSolved", "GDPRActionsTaken", "GDPRDataSubjectIsChild", "GDPRIndirectDataProvider", "GDPRDataProvider", "GDPRIncludesSensitiveData", "GDPRDataDeIdentified", "GDPRNotifyExternalProcessor", "GDPRIncidentToBeDetermined", "GDPRIncidentInProgress", "ContentType"}), #"Expanded ContentType" = Table.ExpandRecordColumn(#"Removed Other Columns", "ContentType", {"Description", "DisplayFormTemplateName", "DisplayFormUrl", "DocumentTemplate", "DocumentTemplateUrl", "EditFormTemplateName", "EditFormUrl", "Group", "Hidden", "Id", "JSLink", "MobileDisplayFormUrl", "MobileEditFormUrl", "MobileNewFormUrl", "Name", "NewFormTemplateName", "NewFormUrl", "ReadOnly", "SchemaXml", "SchemaXmlWithResourceTokens", "Scope", "Sealed", "StringId", "DescriptionResource", "FieldLinks", "Fields", "NameResource", "Parent", "WorkflowAssociations"}, {"ContentType.Description", "ContentType.DisplayFormTemplateName", "ContentType.DisplayFormUrl", "ContentType.DocumentTemplate", "ContentType.DocumentTemplateUrl", "ContentType.EditFormTemplateName", "ContentType.EditFormUrl", "ContentType.Group", "ContentType.Hidden", "ContentType.Id", "ContentType.JSLink", "ContentType.MobileDisplayFormUrl", "ContentType.MobileEditFormUrl", "ContentType.MobileNewFormUrl", "ContentType.Name", "ContentType.NewFormTemplateName", "ContentType.NewFormUrl", "ContentType.ReadOnly", "ContentType.SchemaXml", "ContentType.SchemaXmlWithResourceTokens", "ContentType.Scope", "ContentType.Sealed", "ContentType.StringId", "ContentType.DescriptionResource", "ContentType.FieldLinks", "ContentType.Fields", "ContentType.NameResource", "ContentType.Parent", "ContentType.WorkflowAssociations"}), #"Removed Columns" = Table.RemoveColumns(#"Expanded ContentType",{"ContentType.Description", "ContentType.DisplayFormTemplateName", "ContentType.DisplayFormUrl", "ContentType.DocumentTemplate", "ContentType.DocumentTemplateUrl", "ContentType.EditFormTemplateName", "ContentType.EditFormUrl", "ContentType.Group", "ContentType.Hidden", "ContentType.JSLink", "ContentType.MobileDisplayFormUrl", "ContentType.MobileEditFormUrl", "ContentType.MobileNewFormUrl", "ContentType.NewFormTemplateName", "ContentType.NewFormUrl", "ContentType.ReadOnly", "ContentType.SchemaXml", "ContentType.SchemaXmlWithResourceTokens", "ContentType.Scope", "ContentType.Sealed", "ContentType.DescriptionResource", "ContentType.FieldLinks", "ContentType.Fields", "ContentType.NameResource", "ContentType.Parent", "ContentType.WorkflowAssociations", "ContentType.Id", "ContentType.StringId"}), #"Expanded GDPRBreachType" = Table.ExpandRecordColumn(#"Removed Columns", "GDPRBreachType", {"TermGuid"}, {"GDPRBreachType.TermGuid"}), #"Expanded GDPRSeverity" = Table.ExpandRecordColumn(#"Expanded GDPRBreachType", "GDPRSeverity", {"TermGuid"}, {"GDPRSeverity.TermGuid"}), #"Expanded GDPRIncludesSensitiveData" = Table.ExpandRecordColumn(#"Expanded GDPRSeverity", "GDPRIncludesSensitiveData", {"TermGuid"}, {"GDPRIncludesSensitiveData.TermGuid"}), #"Renamed Columns1" = Table.RenameColumns(#"Expanded GDPRIncludesSensitiveData",{{"ContentType.Name", "Report Type"}, {"Title", "Report"}, {"GDPRNotifiedBy", "Notified by"}}), #"Inserted Date" = Table.AddColumn(#"Renamed Columns1", "Start Date", each DateTime.Date([GDPRReportStartDateTime]), type date), #"Inserted Time" = Table.AddColumn(#"Inserted Date", "Start Time", each DateTime.Time([GDPRReportStartDateTime]), type time), #"Inserted Date1" = Table.AddColumn(#"Inserted Time", "End Date", each DateTime.Date([GDPRReportEndDateTime]), type date), #"Inserted Time1" = Table.AddColumn(#"Inserted Date1", "End Time", each DateTime.Time([GDPRReportEndDateTime]), type time), #"Extracted Date" = Table.TransformColumns(#"Inserted Time1",{{"GDPRDPANotificationDate", DateTime.Date}}), #"Removed Columns1" = Table.RemoveColumns(#"Extracted Date",{"GDPRReportStartDateTime", "GDPRReportEndDateTime"}), #"Renamed Columns2" = Table.RenameColumns(#"Removed Columns1",{{"GDPRDPANotified", "DPA Notified"}, {"GDPRDPANotificationDate", "DPA Notification Date"}, {"GDPREstimatedAffectedDataSubject", "Estimated Affected Data Subject"}, {"GDPRIncludesChildrenData", "Includes Children Data"}, {"GDPRPlannedRecoveryAction", "Planned Recovery Action"}, {"GDPRBreachSolved", "Breach Solved"}, {"GDPRActionsTaken", "Actions Taken"}, {"GDPRDataSubjectIsChild", "Data Subject Is Child"}, {"Notified by", "Notified By"}, {"GDPRIndirectDataProvider", "Indirect Data Provider"}, {"GDPRDataProvider", "Data Provider"}, {"GDPRNotifyExternalProcessor", "Notify External Processor"}}), #"Merged Queries" = Table.NestedJoin(#"Renamed Columns2",{"ContentTypeId"},ContentTypeCodes,{"ContentTypeId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"Category", "ContentTypeCode"}, {"NewColumn.Category", "NewColumn.ContentTypeCode"}), #"Renamed Columns3" = Table.RenameColumns(#"Expanded NewColumn",{{"NewColumn.Category", "Category"}, {"NewColumn.ContentTypeCode", "ContentTypeCode"}}), #"Removed Columns2" = Table.RemoveColumns(#"Renamed Columns3",{"ContentTypeId"}), #"Merged Queries1" = Table.NestedJoin(#"Removed Columns2",{"GDPRBreachType.TermGuid"},Taxonomy,{"TermId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn1" = Table.ExpandTableColumn(#"Merged Queries1", "NewColumn", {"TermName", "TermCode"}, {"NewColumn.TermName", "NewColumn.TermCode"}), #"Renamed Columns4" = Table.RenameColumns(#"Expanded NewColumn1",{{"NewColumn.TermName", "Breach Type"}, {"NewColumn.TermCode", "BreachTypeCode"}}), #"Removed Columns3" = Table.RemoveColumns(#"Renamed Columns4",{"GDPRBreachType.TermGuid"}), #"Merged Queries2" = Table.NestedJoin(#"Removed Columns3",{"GDPRSeverity.TermGuid"},Taxonomy,{"TermId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn2" = Table.ExpandTableColumn(#"Merged Queries2", "NewColumn", {"TermName", "TermCode"}, {"NewColumn.TermName", "NewColumn.TermCode"}), #"Renamed Columns5" = Table.RenameColumns(#"Expanded NewColumn2",{{"NewColumn.TermName", "Severity"}, {"NewColumn.TermCode", "SeverityCode"}}), #"Removed Columns4" = Table.RemoveColumns(#"Renamed Columns5",{"GDPRSeverity.TermGuid"}), #"Merged Queries3" = Table.NestedJoin(#"Removed Columns4",{"GDPRIncludesSensitiveData.TermGuid"},Taxonomy,{"TermId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn3" = Table.ExpandTableColumn(#"Merged Queries3", "NewColumn", {"TermName", "TermCode"}, {"NewColumn.TermName", "NewColumn.TermCode"}), #"Renamed Columns6" = Table.RenameColumns(#"Expanded NewColumn3",{{"NewColumn.TermName", "Sensitive Data"}, {"NewColumn.TermCode", "SensitiveDataCode"}}), #"Removed Columns5" = Table.RemoveColumns(#"Renamed Columns6",{"GDPRIncludesSensitiveData.TermGuid"}), #"Renamed Columns7" = Table.RenameColumns(#"Removed Columns5",{{"Report Type", "Event Type"}, {"Report", "Event"}, {"GDPRIncidentToBeDetermined", "To Be Determined"}, {"GDPRIncidentInProgress", "In Progress"}, {"GDPRDataDeIdentified", "Anonymize"}}), #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns7",{{"DPA Notified", type logical}, {"Includes Children Data", type logical}, {"Breach Solved", type logical}, {"Data Subject Is Child", type logical}, {"Indirect Data Provider", type logical}, {"Notify External Processor", type logical}, {"To Be Determined", type logical}, {"In Progress", type logical}, {"Anonymize", type logical}}), #"Renamed Columns8" = Table.RenameColumns(#"Changed Type",{{"Id", "EventId"}}), #"Split Column by Delimiter" = Table.SplitColumn(#"Renamed Columns8", "Event Type", Splitter.SplitTextByEachDelimiter({"–"}, QuoteStyle.Csv, false), {"Event Type.1", "Event Type.2"}), #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Event Type.1", type text}, {"Event Type.2", type text}}), #"Removed Columns6" = Table.RemoveColumns(#"Changed Type1",{"Event Type.1"}), #"Renamed Columns9" = Table.RenameColumns(#"Removed Columns6",{{"Event Type.2", "Event Type"}}) in #"Renamed Columns9"; shared Requests = let Source = SharePoint.Tables(#"Sharepoint GDPR URL", [ApiVersion = 15]), #"daa1dfec-c9e4-42ea-8006-765b67a8be7d" = Source{[Title="Requests"]}[Items], #"Extracted First Characters" = Table.TransformColumns(#"daa1dfec-c9e4-42ea-8006-765b67a8be7d", {{"ContentTypeId", each Text.Start(_, 40), type text}}), #"Expanded GDPRRequestAssignedTo" = Table.ExpandRecordColumn(#"Extracted First Characters", "GDPRRequestAssignedTo", {"DisplayName", "Name", "EMail"}, {"GDPRRequestAssignedTo.DisplayName", "GDPRRequestAssignedTo.Name", "GDPRRequestAssignedTo.EMail"}), #"Removed Columns3" = Table.RemoveColumns(#"Expanded GDPRRequestAssignedTo",{"GDPRRequestAssignedTo.DisplayName", "GDPRRequestAssignedTo.Name"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns3",{{"ID", "ID.1"}, {"GDPRRequestAssignedTo.EMail", "Assigned To"}}), #"Expanded ContentType" = Table.ExpandRecordColumn(#"Renamed Columns", "ContentType", {"Description", "DisplayFormTemplateName", "DisplayFormUrl", "DocumentTemplate", "DocumentTemplateUrl", "EditFormTemplateName", "EditFormUrl", "Group", "Hidden", "Id", "JSLink", "MobileDisplayFormUrl", "MobileEditFormUrl", "MobileNewFormUrl", "Name", "NewFormTemplateName", "NewFormUrl", "ReadOnly", "SchemaXml", "SchemaXmlWithResourceTokens", "Scope", "Sealed", "StringId", "DescriptionResource", "FieldLinks", "Fields", "NameResource", "Parent", "WorkflowAssociations"}, {"ContentType.Description", "ContentType.DisplayFormTemplateName", "ContentType.DisplayFormUrl", "ContentType.DocumentTemplate", "ContentType.DocumentTemplateUrl", "ContentType.EditFormTemplateName", "ContentType.EditFormUrl", "ContentType.Group", "ContentType.Hidden", "ContentType.Id", "ContentType.JSLink", "ContentType.MobileDisplayFormUrl", "ContentType.MobileEditFormUrl", "ContentType.MobileNewFormUrl", "ContentType.Name", "ContentType.NewFormTemplateName", "ContentType.NewFormUrl", "ContentType.ReadOnly", "ContentType.SchemaXml", "ContentType.SchemaXmlWithResourceTokens", "ContentType.Scope", "ContentType.Sealed", "ContentType.StringId", "ContentType.DescriptionResource", "ContentType.FieldLinks", "ContentType.Fields", "ContentType.NameResource", "ContentType.Parent", "ContentType.WorkflowAssociations"}), #"Removed Other Columns" = Table.SelectColumns(#"Expanded ContentType",{"Id", "ContentTypeId", "Title", "GDPRDataSubject", "GDPRDataSubjectEmail", "GDPRRequestInsertionDate", "GDPRDeliveryMethod", "GDPRPersonalData", "ContentType.Name", "Assigned To"}), #"Renamed Columns1" = Table.RenameColumns(#"Removed Other Columns",{{"ContentType.Name", "ContentTypeName"}}), #"Expanded GDPRDeliveryMethod" = Table.ExpandRecordColumn(#"Renamed Columns1", "GDPRDeliveryMethod", {"Label", "TermGuid", "WssId"}, {"GDPRDeliveryMethod.Label", "GDPRDeliveryMethod.TermGuid", "GDPRDeliveryMethod.WssId"}), #"Removed Columns" = Table.RemoveColumns(#"Expanded GDPRDeliveryMethod",{"GDPRDeliveryMethod.Label", "GDPRDeliveryMethod.WssId"}), #"Renamed Columns2" = Table.RenameColumns(#"Removed Columns",{{"GDPRRequestInsertionDate", "Insertion Date"}, {"GDPRDataSubjectEmail", "Data Subject Mail"}, {"GDPRDataSubject", "Data Subject"}, {"Title", "Request"}, {"ContentTypeName", "Request Type"}, {"GDPRDeliveryMethod.TermGuid", "DeliveryMethodId"}, {"GDPRPersonalData", "Personal Data"}}), #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns2",{{"Insertion Date", type date}}), #"Merged Queries" = Table.NestedJoin(#"Changed Type",{"DeliveryMethodId"},Taxonomy,{"TermId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"TermName", "TermCode"}, {"NewColumn.TermName", "NewColumn.TermCode"}), #"Renamed Columns3" = Table.RenameColumns(#"Expanded NewColumn",{{"NewColumn.TermName", "Delivery Method"}, {"NewColumn.TermCode", "DeliveryMethodCode"}}), #"Removed Columns1" = Table.RemoveColumns(#"Renamed Columns3",{"DeliveryMethodId"}), #"Merged Queries1" = Table.NestedJoin(#"Removed Columns1",{"ContentTypeId"},ContentTypeCodes,{"ContentTypeId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn1" = Table.ExpandTableColumn(#"Merged Queries1", "NewColumn", {"Category", "ContentTypeCode"}, {"NewColumn.Category", "NewColumn.ContentTypeCode"}), #"Renamed Columns4" = Table.RenameColumns(#"Expanded NewColumn1",{{"NewColumn.Category", "Category"}, {"NewColumn.ContentTypeCode", "ContentTypeCode"}}), #"Removed Columns2" = Table.RemoveColumns(#"Renamed Columns4",{"ContentTypeId"}), #"Renamed Columns5" = Table.RenameColumns(#"Removed Columns2",{{"Id", "RequestId"}}), #"Split Column by Delimiter" = Table.SplitColumn(#"Renamed Columns5", "Request Type", Splitter.SplitTextByEachDelimiter({"–"}, QuoteStyle.Csv, false), {"Request Type.1", "Request Type.2"}), #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Request Type.1", type text}, {"Request Type.2", type text}}), #"Removed Columns4" = Table.RemoveColumns(#"Changed Type1",{"Request Type.1"}), #"Renamed Columns6" = Table.RenameColumns(#"Removed Columns4",{{"Request Type.2", "Request Type"}}) in #"Renamed Columns6"; shared TaxonomyCodes = let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fVXbbhtHDP0XP4fA3C+PirS2F5G1xmqduA0CgZzL/39Cz6zsNijQvko8HPJcuD9/PsSYdKwmk/WmkxMbKNlSKHE0nlOsksPDl4d5u12n49s6b3/c5uv1bXr49eXnQ7cxmeA0NS6eXEmWcjGOPIduk4qVlQb4CNh8PJx3TPUtBNc1ueqAkaZJgk+kqygJNiSuMh48TZdtvLY9T4/bjmTh6rhkMsUJORcapW4r9ZZNUqq7yBnI18P1+mNZT7fzcr3uwCScQrCKiigmF0SR9FiIjY+mxuBqZgCf56fnvb6pnmL3nmJNkVzTjSSyp1HddeeEn0f94fhtvjzdIdG7wmP/lBo5HyolIxUQb4o3uZY6IKd5nY7bbXo5zOfby2H9Nm2fHbrVreRaKaiI7YLPxLk6yqaZVoMOku3ocNgOt8uyvhzO85+HbV4ud3TDHoUNRo6VnPJCKdhCUTXokHMqjXclphOkPB5+p6dFCZKcIw5o4KKqYEZDER2lJmNrljH7tD1f5uNtWeen+f4o3sTKrlEJMJAzrRNLdiBLdI2+et/D/y/degwRdJJXwxEF8nCCPClVEzQaejWWHshPSE5atRYNhdiwqUCh3GImLOkNusVi1XDB83KZsOj5fF8y5yi5ApZSwJKmBsCqJwMzmsAhZ9sBu14vvxHTTGHXLYXaIcmYU1IrZLv4wFx7iPt04PTtZUegkzOKE0EtvJJbgyGKoiZSoatvZt9np2IHWF1DM6jNBrlxDQKweBgbepfUWGCGodv1+93JXVyMrpDpmkd4eDjTETpLb/hDavk0yeu6bOAdDrktj4/zcVr3FqqU7LV4Ar8IfB2ebVkN/myxRVXtG1o8nV7X23G5bOtyPn9Am0lsSgxYRyly3XfKvkUoYcU4yeJq/YTi9eN0vS53ZGAtXQxM6ZpFPJyCuZWjHrSXKi4pN0R7XuGPy+Hp472qkFeHUbkyRm0qgRyDGFtRhnVjx20P/OsHIDsDP+AkNMewk8tCuYqQ74YzZrA5DCfDGad1/j7dHpf19vXtOl+mD8Wj12w9KGHb4Wi4EjGqDQcNd8qE2KsfDV5Pj3f1En4UB1Mpm/CegX0DjqfigDnh7ZA8ytftXq64mljgQe0ZLBTwIQyzJF+sSzE3ywnl2/vHvWu9FBsUjRBCKR1JECvKMaSWa1eYDOXv5+v7Xu9L7sZLIZ3GDcigC1ccw/fkutJcuMs/YfpXEnFOU4L0pJsbSWR8BwL4M3VM3TuWG+Dt8AKy/46vyj6XHMnXAjs6jQMQc6EGMwepuac8DHFefuzlkjlYEdy0NtyrwUTuHujMqvkQtS76v45UtozbgqOoWPkhLbqEglNb4Hqbaiw7d1/n5WXaVtypkYG7SKVI7NbiC9cQsQB1kxhNJvfuqy2hyRDpdTnfv1K35XW+IDV499df", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"IdForTerm#(lf)IdForTerm" = _t, TermCode = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"IdForTerm#(lf)IdForTerm", type text}, {"TermCode", type text}}) in #"Changed Type"; shared ContentTypeCodes = let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("pdE9T8QwDAbg/9L5BuejaTu6iUsDpTklgQOdqkw38y3x82klJKiqk8ixefFj+/XxWMAnMABkSnFmBJlOdkyyWlZKQtdAWWPZVgJYsSv86eXj9PY+V6g1hZD25IMbcUgGIxbT7s+aXGn0sHc+Xq7xlaad96T/wZUrzrXXs2bdmKJLe++Ww+14lVx3+QSxPt9joLNYW4KSSnAG2BghATkBAUJdN0bXDf/+zPPT62Itzan1hLrPMfhvwxoao42Pydtwk6OIzSY/eeU41cZBr3t7TyZHURvlFs2c8107WJ0DyQ2k3RjmjHKQ8hySDjb2xuMBh2KavgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ContentTypeId = _t, Category = _t, ContentTypeCode = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"ContentTypeId", type text}, {"Category", type text}, {"ContentTypeCode", type text}}) in #"Changed Type"; shared RequestsProcessingTypes = let Source = SharePoint.Tables(#"Sharepoint GDPR URL", [ApiVersion = 15]), #"daa1dfec-c9e4-42ea-8006-765b67a8be7d" = Source{[Title="Requests"]}[Items], #"Expanded GDPRRequestAssignedTo" = Table.ExpandRecordColumn(#"daa1dfec-c9e4-42ea-8006-765b67a8be7d", "GDPRRequestAssignedTo", {"DisplayName", "Name", "EMail"}, {"GDPRRequestAssignedTo.DisplayName", "GDPRRequestAssignedTo.Name", "GDPRRequestAssignedTo.EMail"}), #"Removed Other Columns1" = Table.SelectColumns(#"Expanded GDPRRequestAssignedTo",{"GDPRProcessingType", "ID"}), #"Expanded GDPRProcessingType" = Table.ExpandListColumn(#"Removed Other Columns1", "GDPRProcessingType"), #"Expanded GDPRProcessingType1" = Table.ExpandRecordColumn(#"Expanded GDPRProcessingType", "GDPRProcessingType", {"TermGuid"}, {"GDPRProcessingType.TermGuid"}), #"Merged Queries" = Table.NestedJoin(#"Expanded GDPRProcessingType1",{"GDPRProcessingType.TermGuid"},Taxonomy,{"TermId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"TermName", "TermCode"}, {"NewColumn.TermName", "NewColumn.TermCode"}), #"Renamed Columns" = Table.RenameColumns(#"Expanded NewColumn",{{"NewColumn.TermCode", "ProcessingTypeCode"}, {"NewColumn.TermName", "Processing Type"}}), #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"GDPRProcessingType.TermGuid", "Processing Type"}), #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [ProcessingTypeCode] <> null), #"Renamed Columns1" = Table.RenameColumns(#"Filtered Rows",{{"ID", "RequestId"}}) in #"Renamed Columns1"; shared #"Processing Types" = let Source = SharePoint.Tables(#"Sharepoint GDPR URL", [ApiVersion = 15]), #"daa1dfec-c9e4-42ea-8006-765b67a8be7d" = Source{[Title="Requests"]}[Items], #"Expanded GDPRRequestAssignedTo" = Table.ExpandRecordColumn(#"daa1dfec-c9e4-42ea-8006-765b67a8be7d", "GDPRRequestAssignedTo", {"DisplayName", "Name", "EMail"}, {"GDPRRequestAssignedTo.DisplayName", "GDPRRequestAssignedTo.Name", "GDPRRequestAssignedTo.EMail"}), #"Removed Other Columns1" = Table.SelectColumns(#"Expanded GDPRRequestAssignedTo",{"GDPRProcessingType", "ID"}), #"Expanded GDPRProcessingType" = Table.ExpandListColumn(#"Removed Other Columns1", "GDPRProcessingType"), #"Expanded GDPRProcessingType1" = Table.ExpandRecordColumn(#"Expanded GDPRProcessingType", "GDPRProcessingType", {"TermGuid"}, {"GDPRProcessingType.TermGuid"}), #"Merged Queries" = Table.NestedJoin(#"Expanded GDPRProcessingType1",{"GDPRProcessingType.TermGuid"},Taxonomy,{"TermId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"TermName", "TermCode"}, {"NewColumn.TermName", "NewColumn.TermCode"}), #"Renamed Columns" = Table.RenameColumns(#"Expanded NewColumn",{{"NewColumn.TermCode", "ProcessingTypeCode"}, {"NewColumn.TermName", "Processing Type"}}), #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"GDPRProcessingType.TermGuid", "ID"}), #"Removed Duplicates" = Table.Distinct(#"Removed Columns"), #"Filtered Rows" = Table.SelectRows(#"Removed Duplicates", each [ProcessingTypeCode] <> null) in #"Filtered Rows"; shared EventsRiskTypes = let Source = SharePoint.Tables(#"Sharepoint GDPR URL", [ApiVersion = 15]), #"4e006c08-c0ab-4f71-b94a-b58fc15578c3" = Source{[Title="Events"]}[Items], #"Removed Other Columns1" = Table.SelectColumns(#"4e006c08-c0ab-4f71-b94a-b58fc15578c3",{"GDPRRiskType", "ID"}), #"Expanded GDPRRiskType" = Table.ExpandListColumn(#"Removed Other Columns1", "GDPRRiskType"), #"Expanded GDPRRiskType1" = Table.ExpandRecordColumn(#"Expanded GDPRRiskType", "GDPRRiskType", {"TermGuid"}, {"GDPRRiskType.TermGuid"}), #"Merged Queries" = Table.NestedJoin(#"Expanded GDPRRiskType1",{"GDPRRiskType.TermGuid"},Taxonomy,{"TermId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"TermName", "TermCode"}, {"NewColumn.TermName", "NewColumn.TermCode"}), #"Renamed Columns" = Table.RenameColumns(#"Expanded NewColumn",{{"NewColumn.TermCode", "RiskTypeCode"}, {"NewColumn.TermName", "Risk Type"}}), #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"GDPRRiskType.TermGuid", "Risk Type"}), #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [RiskTypeCode] <> null), #"Renamed Columns1" = Table.RenameColumns(#"Filtered Rows",{{"ID", "EventId"}}) in #"Renamed Columns1"; shared #"Risk Types" = let Source = SharePoint.Tables(#"Sharepoint GDPR URL", [ApiVersion = 15]), #"4e006c08-c0ab-4f71-b94a-b58fc15578c3" = Source{[Title="Events"]}[Items], #"Removed Other Columns1" = Table.SelectColumns(#"4e006c08-c0ab-4f71-b94a-b58fc15578c3",{"GDPRRiskType", "ID"}), #"Expanded GDPRRiskType" = Table.ExpandListColumn(#"Removed Other Columns1", "GDPRRiskType"), #"Expanded GDPRRiskType1" = Table.ExpandRecordColumn(#"Expanded GDPRRiskType", "GDPRRiskType", {"TermGuid"}, {"GDPRRiskType.TermGuid"}), #"Merged Queries" = Table.NestedJoin(#"Expanded GDPRRiskType1",{"GDPRRiskType.TermGuid"},Taxonomy,{"TermId"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"TermName", "TermCode"}, {"NewColumn.TermName", "NewColumn.TermCode"}), #"Renamed Columns" = Table.RenameColumns(#"Expanded NewColumn",{{"NewColumn.TermCode", "RiskTypeCode"}, {"NewColumn.TermName", "Risk Type"}}), #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"GDPRRiskType.TermGuid", "ID"}), #"Removed Duplicates" = Table.Distinct(#"Removed Columns"), #"Filtered Rows" = Table.SelectRows(#"Removed Duplicates", each [RiskTypeCode] <> null) in #"Filtered Rows"; [ Description = "This URL is the GDPR site that will be used to import data in the Power BI model." ] shared #"Sharepoint GDPR URL" = "https://mytenant.sharepoint.com/sites/GDPRActivityHub" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true];