The experience while authoring reports using direct query for SAP data source is sometimes not optimal. Every click sends a query to the data source and we have to wait for the visuals to refresh….
Here is how I work around this issue. It’s not ideal but makes authoring experience a little better.
- From the ribbon, select File -> Options and settings -> Options.
- In the Options dialog, select Query reduction.
- Use the check boxes to reduce cross filtering and enable filter button on slicers and filters.
With this configuration, now I can reduce the number of direct queries while building the visual. It will be ideal to have a pause option so I can complete creating visuals and un-pause once done.