Forum Discussion
Importación datos datos servidor sql
Anonymous ,
On that row, try 'if dataToggle' not 'If dataToggle' i.e. do not capitalise 'if'.
Also, you have misspelled 'toggleStep' in the last line.
Pete
Hi Anonymous ,
Your dataToggle query is literally just this:
let
Source = 1
in
Source
When you want to change the value, you can just select the query and change the value in the formula bar:
Your main query should look like this with no transformations:
let
Origen = Sql.Databases("XXXXX.XX.XXXXXXXX\XXXXX,1111"),
CCCCCC_CCCCCCCC = Origen{[Name=" CCCCCC_CCCCCCCC "]}[Data],
dbo_DDD_DDDDDDD = CCCCCC_CCCCCCCC {[Schema="dbo",Item=" DDD_DDDDDDD "]}[Data],
#"Filas filtradas" = Table.SelectRows(dbo_ DDD_DDDDDDD, each [FILA_ID] >= 652345 and [FILA_ID] <= 653345),
toggleStep = if dataToggle = 1 then #"Filas filtradas" else dbo_DDD_DDDDDDD
in
toggleStep
Then all of your other transformation steps go after toggleStep.
Pete
Buenas nuevamente.
la consulta dataToggle la cree tal como me indicas y en la columna de consultas se visualiza de la siguiente manera.
Pero, en el editor avanzado de la consulta principal, muestra error en la fila 6. No reconoce la expresión dataToggle
Anonymous ,
On that row, try 'if dataToggle' not 'If dataToggle' i.e. do not capitalise 'if'.
Also, you have misspelled 'toggleStep' in the last line.
Pete