Forum Discussion
Incremental refresh - not working?
Anonymous , Have you configured on-premise gateways
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
Also, open the dataset on power bi service check for credential and check the need of scheduled refresh
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
Anonymous Range Start and End should be date/time columns
amitchandak not sure what has a gateway to do with it, data is getting refreshed but seems like the first full load is not happening.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Both RangeStart and RangeEnd are DateTime parameters. My corresponding column on which I put filter is also the datetime column.
My source is Azure SQL, so won't need a gateway. Anyway, refresh is working fine, but doesn't do a full refresh.
It pulls data from June 1st only and should get data from 2018.
Regards
Anonymous that's what I thought that full load is not working, can you share the setting where you have configured the incremental refresh.
Anonymous quick question, are you using import or direct query?
I am using Import.
Below is my query which does indicate the query folding happening
However, in the configuration, it says it is unable to confirm if Query folding is happening or not, so that is weird.
Regards