Forum Discussion

nilimarodrigues's avatar
nilimarodrigues
Icon for Helper III rankHelper 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
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

What I would suggest is to make sure you do not use a custom query to query the data from your source.

You would need to get the data via the navigation. This would then allow it to Query fold back to the source database?
  • nilimarodrigues's avatar
    nilimarodrigues
    Icon for Helper III rankHelper III
    6 years ago

    Hi GilbertQ 

     

    My dataset is not based on a custom query. I am simply utilising Power BI's SAP BW connector to connect to a BEx query. My dataset doesnt have a custom column or formula at all.

     

    Thanks.

     

     

     

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      6 years ago
      Hi there

      And you can confirm that it has got the configuration correctly done for the table to be used?
      • nilimarodrigues's avatar
        nilimarodrigues
        Icon for Helper III rankHelper III
        6 years ago

        Is there any document that talks about what configurations are required?

         

        I am not sure if there is a way I can check or enable query folding for my BW based dataset.