Help with power query code

[Anonymous]

hello to tod@s, I need your help, I am currently connected to a server importing the data. What happens is that the server does not overpend the data when it is updated so it is duplicated; triple, etc. the data.

I have the update dates, however I have no knowledge of a code that allows me to take the last update date, currently only updates me with the update date of October 4:

Let
Source - Sql.Databases("amsazsdw01.database.windows.net"),
amsazsdw01 - Origin-[Name-"amsazsdw01"]-[Data],
amsa_staged_sap_ehs_ZEHS_REP14 . . . . . . . . . . . . . . . . . . . . . . . . . ZEHS_REP14 amsa_staged_sap_ehs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
"Filtered Rows" - Table.SelectRows(amsa_staged_sap_ehs_ZEHS_REP14, each ([COMPANY] ? "Minera Los Pelambres / ID: 187")),
"Removed Columns" - Table.RemoveColumns(-"Filtered Rows","MANDT", "RUT_EMP", "QUESTION1", "QUESTION2", "QUESTION3"-),
"Filtered Rows1" - Table.SelectRows(-"Removed Columns", each ([fecextr2] - #date(2020, 10, 4)))
in
"Filtered Rows1"

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on my tests, there is no option to get the lastest updated datetime. Here is my codes in 'Advanced Editor'.

let
    Source = Sql.Databases("ServerName"),
    test = Source{[Name="DataBaseName"]}[Data]
in
    test

You may try using corresponding names to name the table and then filter the latest one with 'Table.SelectRows'.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.