Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Performance SAP BW

Hi,

 

I am creating a SAP Business Warehouse Application Server connection and setting incremental refresh for some of the tables I used. I am running into perfomance issues. 

 

First of all,  I have seen that in the resulting native query a crossjoin concatenation appears between all selected dimensions.

 

 

 

I have checked the initial configuration and the default parameters have been left in place after not getting a performace improvement. (BasXmlGzip and batch size 50000). 

 

Once uploaded to Power BI Service is setting an incremental refresh policy for the last two months obtaining a refresh time of 8 minutes in the case of forcing the refresh time and about 16 minutes in the case of performing a scheduled refresh. Considering the size of the table, the time should be much less, how can I improve the performance? Is the native query structure normal?

 

Thanks.

2 Replies

  • Anonymous , Are you using a cube or tabular model, can you share the relationship diagram in case of the tabular model

    • Anonymous's avatar
      Anonymous
      Not applicable

      I am using a cube model.