Forum Discussion
Incremental refresh - not working?
Super UserAnonymous , 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
- parry2k
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
- parry2k
Anonymous that's what I thought that full load is not working, can you share the setting where you have configured the incremental refresh.
