Forum Discussion
SAP BW connector, date type & incrmental refresh
Hello, I've been trying to use incremental refresh on a BW datasource but the date native format returned is of type text (preventing folding and thus incremental refresh). I followed the Po...
v-yanjiang-msft
Community Support
Community SupportHi pbt ,
Can you change the data type to date in Power Query. Here's a similar thread for your reference:
Solved: Incorrect local date - Australian format - Microsoft Power BI Community
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your feedback, however, the point of this data typing is to do incremental refresh.
If i change the datatype in Power Query, the query won't fold anymore and thus incremental refresh won't work.
Best regards