Features

BI Reports Proxy includes a myriad of amazing features to help make your Azure and M365 reporting a breeze. If you struggle with 429s and the incredibly long time it takes to run queries against Microsoft APIs, this set of tools and reports are for you. Most of the query and reporting work has been done for you! Quit struggling trying to build Power M Queries for the reporting and compliance APIs.

Proxy Features:

  • Caching of requests with report defined frequency (Hourly, Daily, Monthly, Yearly, etc).
  • Caching of requests based on custom cache keys (such as Azure AD TenantId).
  • Support for custom headers to the backend target.
  • Proxy support for looping records in OData and Microsoft APIs (Microsoft Graph, etc).
  • Azure AD authentication, Azure AD MFA authentication
  • Multiple pre-defined well-known and not so well known Azure AD token endpoints.
  • Encryption of cached data.

Report Features:

  • Support for Log Analytics queries.
  • Support for looping records.
  • User-based encryption keys to encrypt data on the backend.
  • User partitioned queries and cache.
  • Month based filtering that allows you to keep your reports for compliance and auditing purposes.

Future Features:

  • Parquet based export of cached queries to storage accounts.
  • Enhanced MFA support.
  • More reports with helpful visualizations.