The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have setup incremental refresh and It seemed to be working fine, there was no errors and data looked correctly. But after a while one of the user reported that data for last few days are incorrect - some are higher, some are lower than expected. I already eliminated an error with "=" sign on both Range end and range start.
My incremental refresh looks like this:
1. filtered columns in fact tables has datetime type
2. Archived are last 36 months
3. refreshed are last 30 days
I still got worning that "unable to confirm if the M query can be folded" but I suppose it is only related to refresh time and it is not required that query must be folded.
Thanks in advance for your help!
HI @ryszardre,
Thanks for your sharing, I think this type of informations may help others who faced the similar scenario.
Regards,
Xiaoxin Sheng
It turns out that issue is more complicated - I raised a ticket to MS support and for now I got instruction that if native query in power query is inactive (grayed-out) it is then more complicated to implement Incremental Refresh. I will write more when I have more info.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
42 | |
23 | |
23 | |
18 |