Forum Discussion

PBI_Rookie's avatar
PBI_Rookie
Helper I
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 Team

 

If 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