SAP BW connector, date type & incrmental refresh

[pbt]

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 Power Query documentation requirements : Implementation details - Power Query | Microsoft Learn

- Date is of type DATS in BW

- Use BW 2.0 connector: OK

- get the date key: OK - i also tryed with every properties of the date dimension nothings comes out as a date type.

- Import mode : OK

- Account used has accès to BAPI_IOBJ_GETDETAIL : OK (tested in SE37)

Did i miss something? 

Thanks,

Best regards

[v-yanjiang-msft]

Hi @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.

[pbt]

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