applying filters in the dataflow

[Anonymous]

Hello everyone,
I am using Dataflow to extract data from a table with more than 550 million records.
I'm getting an error message regarding timed out.
I thought about separating the old data that will no longer be updated, filtering through the date field to load them the first time, and then doing an incremental process to load the new data.
I did a test with only one month, about 90 million records, and the same error continues to occur.
Are the filters applied in the dataflow not applied when updating the data?

[v-cherch-msft]

Hi @Anonymous 

Please have a look at below article to check if it could help.If it is not your case,you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh

Regards,

[Anonymous]

Hi @v-cherch-msft,

I am late!! sorry...

I was able to apply the filters, but the data volume does not allow me to use the dataflow. After 2 hours of load I get a timeout error message.

Is this 2-hour period a parameter I can change?

regards,

Marcelo