Enhancing Report Speed Using SQL

Generating lengthy reports that evaluate a large number of records can create a processing burden for the data server that may affect the EBMS performance of other uses. Long reports may require a substantial amount of time to generate. Both of these issues can be resolved by generating reports from a mirrored SQL database rather than directly from the EBMS files.   

This speed enhancement option will be most useful for long reports or summaries that use detailed data, such as sales detail or general ledger transactions. The SQL options require the SQL mirror to implement this reporting speed enhancement. Review the SQL Mirror and Power BI Overview section for details on this performance tool.

The option to identify the Data Source is located on the top of the report prompt as shown below. Select SQL Mirror Azure (Default) as the data source.

Review Performance Enhancements for more speed enhancement options.