Forum Discussion
Published Model displays incorrectly
Hello,
I have a pubished report that is displaying some odd behavior and I am unsure of where to start.
The report works well initially and is being updated hourly using incremental refresh connected to the data source with a gateway.
At a certain point the data displayed in the report appears to shift. Information displayed becomes a jumbled mess. Products displayed no longer match the values or timeframes selected etc.
At this point I am republishing my dataset once a day to combat this. Where should I start my troubleshooting?
Thank you
3 Replies
Hi PBI_Rookie ,
How did you define the incremental refresh policy? How are these two parameters set?
Important: Verify queries have an equal to (=) on either RangeStart or RangeEnd, but not both. If the equal to (=) exists on both parameters, a row could satisfy the conditions for two partitions, which could lead to duplicate data in the model. For example, could result in duplicate data.#"Filtered Rows" = Table.SelectRows(dbo_Fact, each [OrderDate] >= RangeStart and [OrderDate] <= RangeEnd)Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Thank you Gao. I've verified that those are correctly set up.
My data source is already restricting the earliest date. Could that plus using a Range start be causing any issues?
Hi PBI_Rookie ,
Can you tell me how long before the refresh date to start incrementally refreshing the data?
If the earliest date set by the data source is within this date, the amount of data in the refresh partition will become less. If Detect data changes is checked, the data in the historical partition may be lost.
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft DocsBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
