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,
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 ?