Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to query day old data ?

Hello, I have a case where I am querying 2 databases. One of which is day old data (lets call this DB1), due to the ETL process, then the other database is live data, (lets call this DB2).   I woul...
Need Help
YJ's avatar
YJ
Resolver II
6 years ago

Hi,m

i chanced upon this and would be interested to know how this is done to fold the query back to SQL side.

I am still learning esp on the M language,

can you explain a bit more the below: 

 

 dbo_TableName= Source{[Schema="dbo",Item="dbo_TableName"]}[Data],

What is `[data ] here, and 

[$Table]

?

 

Thanks

 

edhans's avatar
edhans
Community Champion
6 years ago

Data should say "Database". I forgot to change that when I was removing my specific names.

I have to be honest. I am not sure specifically what [Data] is doing other than telling the server to return data in the specified table. I cannot find the syntax for the Source command.

 

$Table is the variable I guess Power Query generates. I didn't create any of the SQL statement. Just showing what PQ generates.