Forum Discussion
Incremental Refresh when Date field is a YYYYMMDD string
My sales fact table ('TMSDAY') stores the transaction date [TDDATE] as an 8 character string in YYYYMMDD format. Our ERP system stores all date fields this way so I am facing this issue with every f...
Hi Eric
Please refer to the similar solved post:
https://community.powerbi.com/t5/Desktop/Incremental-refresh-with-ID-YYYYMMDD/m-p/437844
v-diye-msft, thank you for the response. I looked at taht post but it doesn't solve my problem. I am able to use that approach in Power BI Desktop but I’m trying to do this in a Dataflow, which to my knowledge doesn’t have the ability to create and use Parameters. If I’m wrong on that front, please correct me.
Any idea how to accomplisy this same thing in Dataflows?