Hi guys,
I'm doing some tests to understand how the incremental refresh works and there is something that I struggle to understand :
I have configured my power query in order to retrieve ONLY data of the day before and I set up the incremental refresh like below
Yesterday (25/04), I refreshed the PBIX so I had the data of 24/04. After, I published it and after checking the report in Service, the dataset had the same data. Today (26/04), the incremental refresh happened well and I noticed that the data of 24/04 has been deleted and there is only data of 25/04. I expected to see data of these 2 days.
Is it normal ?
Thank you in advance !
@bboy0009 , Yes, you should see 2 days/ 2 years of data of data.
Re-run the Refresh manually and check for any error or logic issue.
Make sure the dates/data types are correctly defined
Still does not work log an issue - https://community.powerbi.com/t5/Issues/idb-p/Issues
I have re-run the refresh manually and the result is the same
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
50 | |
49 |
User | Count |
---|---|
163 | |
85 | |
76 | |
68 | |
67 |