Hello
I have an excel file with fuel prices, these fuel prices i get them into excel using power query web connector
Now every month this excel sheet i refresh it to get latest data, then each month also the same excel file is imported into dataverse using dataflows
The issue is that if i press manually publish , it will import same latest data again, am not able to work it out for duplicate detection,
My dataverse table basically consists of month column (which is first of month and year), price of special petrol, and price of e plus petrol, thats it
why in my keys i cant choose eplus and special petrol prices as keys?
How to avoid duplicates during import?
Also how to change months columns to my system date format dd-mm-yyyy?
dataflow
table columns
keys

Report
All responses (
Answers (