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/ . \ \ AccessPolicy to make your data publicly available via FHIR read operation:

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

Azure Active Directory (organizational) authentication&x20;

Configure integration with Azure Active Directory that provides organizational authentication.

Azure AD

Connect Power BI to Aidbox

{:tag "embed", :lines ["{% embed url=\"https://docs.microsoft.com/en-us/power-query/connectors/fhir/fhir#connect-to-a-fhir-server-from-power-query-desktop\" %}"]}