Who is this article for?

  Users creating custom reporting solutions.

Power BI does not natively integrate with Ideagen Internal Audit (Aura) because Power BI cannot directly authenticate to or orchestrate data retrieval from Internal Audit’s REST API.

To connect Power BI to Aura, customers must build (or use) an intermediate connector application that retrieves data from Aura’s REST API, transforms it as needed, and exposes it in a Power BI‑compatible format.

This article explains why this is necessary and outlines example approaches.

Issue

Customers may attempt to connect Power BI directly to Ideagen Internal Audit (Aura)’s REST API.  This does not work, due to:

• Authentication Requirements:  Aura’s REST API uses a token‑based authentication that Power BI’s native connectors cannot directly handle.
• API Pagination and Query Handling requirements.
• Request patterns:  which can exceed the API's rate limits unless mediated.

Because of these factors, the API does not provide direct support for Power BI.

Instead, an intermediary service is needed to fetch and prepare data.

Solution

To successfully use Power BI with Aura, create a custom connector application that:

• Authenticates to the REST API
• Retrieves, paginates, and aggregates the data, within usage limits
• Exposes it to Power BI via a supported method