The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |