Forum Discussion
How to read BW Date field as DateTime for incremental refresh
Thank you for the link, Yolo. I tried that, but unfortunately, it appears this only works for dates stored and detected as numeric. The SAP BW connector reads date field level 1 values as type Text and date key properties as type Date. Unless I'm misunderstanding this workaround, it looks like I need to convert the key to DateTime to get it to work out of the box or the Text field to Integer for the workaround, both of which disable query folding.
Am I missing something, or am I painted into a corner until Microsoft delivers the ability to drive incremental refresh based on Date as well as DateTime?
Hi Anonymous
Maybe you can add a custom column and use Datetime.Fromtext() in power query to translate the text column to datetime column,
e.g:
= Table.AddColumn(Source, "Custom", each DateTime.FromText([Column1],[Format="yyyyMMdd", Culture="en-US"]))
You can refer to the following link:
DateTime.FromText - PowerQuery M | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, Yolo. Adding a custom column disables query folding, so it doesn't solve my incremental refresh conundrum. I appreciate your suggestions, though.
kenichisegawaMicrosoft Employee
Hi Anonymous
I'm facing the same issue, have you ever get this use case worked? If so, sharing your workaround would be really appreciated.
Hi Kenichi. Unfortunately, we've not yet found a solution.