Power BI

Export Aidbox data to Power BI

Prerequisites

• Use stable, latest or edge Aidbox version

• Set up the correct Aidbox instance URL in AIDBOX_BASE_URL environment variable

• Set AIDBOX_COMPLIANCE environment variable

Authenticate Power BI connection in Aidbox

Power BI offers two authentication modes:

Anonymous access

This mode requires you to have your data publicly available. Power BI needs access to FHIR read operation GET /fhir/<resourceType> . AccessPolicy to make your data publicly available via FHIR read operation:

id: allow-read-all-resources
resourceType: AccessPolicy
link:
  - id: FhirRead
    resourceType: Operation
engine: allow

Azure Active Directory (organizational) authentication

Configure integration with Azure Active Directory that provides organizational authentication.

How to configure Azure AD SSO for access to the Aidbox UI

Connect Power BI to Aidbox

Power Query connector for FHIR - Power Querydocsmsft