Improving authoring experience for SAP Direct Query reports

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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s