---------- Message ---------- Failed to execute 'ariaNotify' on 'Document': Failed to read the 'priority' property from 'AriaNotificationOptions': The provided value 'none' is not a valid enum value of type AriaNotifyPriority. ---------- Pile ---------- React.useCallback(()@webpack://node_modules/@fluentui/react-aria/lib/AriaLiveAnnouncer/useAriaNotifyAnnounce.js:21:23 announce()@webpack://@powerquery/monolith-ui/ClientShared/Scripts/Components/Dialog/DialogRenderer.tsx:33:45 ---------- ID de session ---------- 7a0206f0-5582-48e6-ab4c-5adcb1e33c77 ---------- Script Mashup ---------- [DefaultOutputDestinationSettings = [DestinationDefinition = [Kind = "Reference", QueryName = "DefaultDestination", IsNewTarget = true], UpdateMethod = [Kind = "Append"], DestinationTypeSettings = [Kind = "Table"]], StagingDefinition = [Kind = "FastCopy"]] section Section1; shared DefaultDestination = Fabric.Warehouse([CreateNavigationProperties = false]){[workspaceId = "a848bdde-71f0-49ec-b240-6e06f0a722ef"]}[Data]{[warehouseId = "8de00ccf-30b3-4684-86b5-40e8f47cf812"]}[Data]; [BindToDefaultDestination = true] shared dim_client = let Source = AzureStorage.DataLake("https://massarfabric.dfs.core.windows.net/"), #"Lignes filtrées" = Table.SelectRows(Source, each Text.Contains([Name], "wwi.dimension_Customer.txt")), Navigation = #"Lignes filtrées"{[#"Folder Path" = "https://massarfabric.dfs.core.windows.net/sampledata/", Name = "wwi.dimension_Customer.txt"]}[Content], #"CSV importé" = Csv.Document(Navigation, [Delimiter = ",", Columns = 11, Encoding = 65001, QuoteStyle = QuoteStyle.None]), #"En-têtes promus" = Table.PromoteHeaders(#"CSV importé", [PromoteAllScalars = true]), #"Type de colonne changé" = Table.TransformColumnTypes(#"En-têtes promus", {{"Customer Key", Int64.Type}, {"WWI Customer ID", Int64.Type}, {"Customer", type text}, {"Bill To Customer", type text}, {"Category", type text}, {"Buying Group", type text}, {"Primary Contact", type text}, {"Postal Code", Int64.Type}, {"Valid From", type datetime}, {"Valid To", type datetime}, {"Lineage Key", Int64.Type}}, "fr"), #"Lignes vides supprimées" = Table.SelectRows(#"Type de colonne changé", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))), #"Premières lignes supprimées" = Table.Skip(#"Lignes vides supprimées", 1) in #"Premières lignes supprimées"; [BindToDefaultDestination = true] shared nouveaux_client = let Source = AzureStorage.DataLake("https://massarfabric.dfs.core.windows.net/"), #"Lignes filtrées" = Table.SelectRows(Source, each Text.Contains([Name], "wwi.nouveaux_clients.txt")), Navigation = #"Lignes filtrées"{[#"Folder Path" = "https://massarfabric.dfs.core.windows.net/sampledata/", Name = "wwi.nouveaux_clients.txt"]}[Content], #"CSV importé" = Csv.Document(Navigation, [Delimiter = ",", Columns = 11, Encoding = 65001, QuoteStyle = QuoteStyle.None]), #"En-têtes promus" = Table.PromoteHeaders(#"CSV importé", [PromoteAllScalars = true]), #"Type de colonne changé" = Table.TransformColumnTypes(#"En-têtes promus", {{"Customer Key", Int64.Type}, {"WWI Customer ID", Int64.Type}, {"Customer", type text}, {"Bill To Customer", type text}, {"Category", type text}, {"Buying Group", type text}, {"Primary Contact", type text}, {"Postal Code", Int64.Type}, {"Valid From", type datetime}, {"Valid To", type datetime}, {"Lineage Key", Int64.Type}}, "fr"), #"Lignes vides supprimées" = Table.SelectRows(#"Type de colonne changé", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))), #"Premières lignes supprimées" = Table.Skip(#"Lignes vides supprimées", 1) in #"Premières lignes supprimées"; [StagingDefinition = [Kind = "FastCopy", Required = true], DataDestinations = {[Definition = [Kind = "Reference", QueryName = "dim_customer_DataDestination", IsNewTarget = true], Settings = [Kind = "Manual", AllowCreation = true, ColumnSettings = [Mappings = {[SourceColumnName = "Customer Key", DestinationColumnName = "Customer Key"], [SourceColumnName = "WWI Customer ID", DestinationColumnName = "WWI Customer ID"], [SourceColumnName = "Customer", DestinationColumnName = "Customer"], [SourceColumnName = "Bill To Customer", DestinationColumnName = "Bill To Customer"], [SourceColumnName = "Category", DestinationColumnName = "Category"], [SourceColumnName = "Buying Group", DestinationColumnName = "Buying Group"], [SourceColumnName = "Primary Contact", DestinationColumnName = "Primary Contact"], [SourceColumnName = "Postal Code", DestinationColumnName = "Postal Code"], [SourceColumnName = "Valid From", DestinationColumnName = "Valid From"], [SourceColumnName = "Valid To", DestinationColumnName = "Valid To"], [SourceColumnName = "Lineage Key", DestinationColumnName = "Lineage Key"]}], DynamicSchema = false, UpdateMethod = [Kind = "Replace"], TypeSettings = [Kind = "Table"]]]}] shared dim_customer = let Source = Table.Combine({dim_client, nouveaux_client}), #"Type de colonne changé" = Table.TransformColumnTypes(Source, {{"Postal Code", Int64.Type}, {"Valid From", type datetime}, {"Valid To", type datetime}}) in #"Type de colonne changé"; shared dim_customer_DataDestination = let Pattern = Fabric.Warehouse([HierarchicalNavigation = null, CreateNavigationProperties = false]), Navigation_1 = Pattern{[workspaceId = "a848bdde-71f0-49ec-b240-6e06f0a722ef"]}[Data], Navigation_2 = Navigation_1{[warehouseId = "8de00ccf-30b3-4684-86b5-40e8f47cf812"]}[Data], TableNavigation = Navigation_2{[Item = "dim_customer", Schema = "dbo"]}?[Data]? in TableNavigation;
... View more