Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
---------- 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.
Please reach out to our support team by raising a support ticket so they can better assist you:
Microsoft Fabric Support and Status | Microsoft Fabric