Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to read BW Date field as DateTime for incremental refresh

I have a Date field coming from an SAP BW BEx query, and I'd like to read it as DateTime for driving incremental refresh of my dataflow. Power BI autodetects the key as Date type. I can convert it to...
dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you, Yolo. Adding a custom column disables query folding, so it doesn't solve my incremental refresh conundrum. I appreciate your suggestions, though.

kenichisegawa's avatar
kenichisegawa
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Kenichi. Unfortunately, we've not yet found a solution.