Forum Discussion

pbt's avatar
pbt
Regular Visitor
4 years ago

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 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

Need Help

2 Replies

    • pbt's avatar
      pbt
      Regular Visitor
      3 years ago

      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