Merci, j’ai réussi a refaire le code, par contre, j’obtiens le message d’erreur suivant:
Formula.Firewall: Query ‘Contrats’ (step ‘Filtered Rows’) is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination
Voici mon code:
let
Parameters = Excel.CurrentWorkbook(){[Name=”Parameters”]}[Content],
Account = Table.SelectRows(Parameters, each [Name of Parameter] = “Account”){0}[Value],
Source = Sql.Database(“vdb1”, “Wynne”),
dbo_Contrats = Source{[Schema=”dbo”,Item=”Contrats”]}[Data],
#”Filtered Rows” = Table.SelectRows(dbo_Contrats, each ([#”Account #”] = Account))
in
#”Filtered Rows”
Merci de votre aide
Marc-André
, le il y a 8 années et 9 mois.
