Forum Discussion
naelske_cronos
Advocate II
Advocate IIIncremental Refresh fails at around 2 AM
Hello, I have set up incremental refresh on my Power BI report for 3 tables with the correct set up of my parameters RangeStart and RangeEnd. I'm working with the Flow Power Automate to refresh m...
Is the file date meaningful? Can it be used as part of the PK ?
lbendlin
Super User
Super UserIs the file date meaningful? Can it be used as part of the PK ?
naelske_cronosAdvocate II
Advocate IIHello lbendlin ,
That's a good idea. A concatenation of category and index was not enough like in the image. I've used some other fields like the datetime and the incremental refresh worked during the day change! As I only keep data for 7 days some rows are removed and new ones are added again, the 'Table.AddIndexColumn' always creates new index values sequentially and there was the problem of having two times 'Monitoring Exercise - 1691'.
Thanks again!
Kind regards