How to pull data from a table from spesific date?

[Anonymous]

Hi all,

I use ODBC to connect to a table.

The table contains many rows (more then I need).

How can I get data from the table after a specific date without pulling all table before?

Thanks,

[dax]

Hi @Anonymous , 

You could try to use M code like below to filter data

= Table.SelectRows(#"Changed Type", each [Column1] <=#date(2020,5,19))

Best Regards,
Zoe Zhi

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

[camargos88]

Hi @Anonymous ,

Use can use Query Folding for that.

After import the data, create a parameter or/and filter the data. So the engine will make the query for this range of data instead of all data.

https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding

https://docs.microsoft.com/en-us/power-query/power-query-folding

[Anonymous]

Hi @camargos88 ,

I tried to use folding as wrote in the links, but I have an error that I didn't connect to the relevant table (I'm connected to DSN).

It looks like I miss something.

Can you show some examples above the links?

[camargos88]

@Anonymous ,

What is the error ? Also the source ?