Forum Discussion

nilimarodrigues's avatar
nilimarodrigues
Helper III
6 years ago

Incremental refresh with SAP BW datasource

Hi All,   I am trying to implement "Incremental Refresh" approach for Power BI dashboard based on SAP BW data source. Our SAP BW system is based on a Non-HANA database.    I applied the steps gi...
Need Help
nilimarodrigues's avatar
nilimarodrigues
Helper III
6 years ago

Hi v-xuding-msft ,

 

As I mentioned in my original post, not having "Query Folding" on dataset is a problem for me.

 

I tried to create one more test dataset based on SAP BW. Simply drag three fields - Posting Date, Amount and Currency Type.

Now in SAP BW, posting date is of type "DATE" format but when the data is imported it comes up as "TEXT" format. The moment, I change the type from "TEXT" to "DATE", query folding is simply gone for my SAP BW based dataset.

 

Incremental refresh ONLY works for date or date/time based fields as well as when "Query Folding" is possible.

How am I supposed to achieve "Incremental refresh" when meeting both of these requirements is conflicting with each other?

 

Thanks,

Nilima

 

 

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi nilimarodrigues ,

    After researching, I find that many users encounter the problem of Query Folding broken when change data type from TEXT to DATE. I don't know if it is by design or it is a issue. I think you could create a support ticket to get an exact answer and get help about incremental refresh with SAP BW.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.