Forum Discussion
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
- amitchandakSuper User
Anonymous , Are you using a cube or tabular model, can you share the relationship diagram in case of the tabular model
- AnonymousNot applicable
I am using a cube model.