Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
---------- 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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.