Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
43 | |
41 | |
39 | |
36 |