Forum Discussion
How to pull data from a table from spesific date?
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,
4 Replies
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
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?
Anonymous ,
What is the error ? Also the source ?
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
