Forum Discussion
Incremental refresh - not working?
Hello,
I am implementing an incremental refresh for one of my reports.
Here are the steps I did -
1. Created parameters for RangeStart and RangeEnd with their values as 6/1/2020 and 12/31/2020 (these dates so as to not make my PBIX file huge)
2. I filtered rows for my query to pull data from RangeStart to RangeEnd.
3. After Close & Apply, it gives me data starting June 1st till date.
4. I configured incremental refresh for this query to pull data for last 3 years and refresh for last 1 day only.
5. After I published this report to Service and refreshed it (on demand), it gives me data from 6/1/2020 although I do have data starting 2018 in my SQL server database.
So, I wonder what part of configuation is not working as this seems to be quite straight forward to do.
Any inputs?
Regards
8 Replies
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
