Edit

Share via

Set up your FHIR data connection

This article outlines the steps to create a FHIR data connection.

Supported authentication types

The FHIR connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type Copy Dataflow Gen2
Anonymous n/a √
Organizational account n/a √

Set up your connection for Dataflow Gen2

You can connect Dataflow Gen2 in Microsoft Fabric to FHIR using Power Query connectors. Follow these steps to create your connection:

  1. Check capabilities to make sure your scenario is supported.
  2. Complete prerequisites for FHIR data.
  3. Get data in Fabric.
  4. Connect to a FHIR server.

Capabilities

  • Import

Prerequisites

You must have a FHIR Data Reader role on the FHIR server to read data from the server. More information: Assign roles for the FHIR service

Get data

To get data in Data Factory:

  1. On the left side of Data Factory, select Workspaces.

  2. From your Data Factory workspace, select New > Dataflow Gen2 to create a new dataflow.

    Screenshot showing the workspace where you choose to create a new dataflow.

  3. In Power Query, either select Get data in the ribbon or select Get data from another source in the current view.

    Screenshot showing the Power Query workspace with the Get data option emphasized.

  4. In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.

    Screenshot of the Data Factory Choose data source page with the search box and the view more selection emphasized.

  5. If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.

    Screenshot of the Data Factory Choose data source page displayed after selecting view more, with the list of connectors.

Connect to a FHIR server

To make a connection to a FHIR server, take the following steps:

  1. In Choose data source, search for FHIR, and then select the FHIR connector. More information: Where to get data

  2. In the FHIR dialog, enter the URL for your FHIR server.

    Screenshot of the FHIR dialog with the FHIR URL filled in.

    You can optionally enter an initial query for the FHIR server, if you know exactly what data you're looking for.

  3. If necessary, include the name of your on-premises data gateway.

  4. Select the Organizational account authentication kind, and select Sign in. Enter your credentials when asked. You must have a FHIR Data Reader role on the FHIR server to read data from the server.

  5. Select Next to proceed.

  6. Select the resources you're interested in.

    Screenshot of the Navigator with the FHIR Patient box filled in, and the patient records shown on the right hand side.

    Select Transform data to shape the data.

  7. Shape the data as needed, for example, expand the postal code.

    Screenshot of the Power Query editor with the address column selected, and the postal code selected for expansion.

  8. Save the query when shaping is complete.

    Screenshot of the Power Query editor with the Save & Close button emphasized.

    Note

    In some cases, query folding can't be obtained purely through data shaping with the graphical user interface (GUI), as shown in the previous image. To learn more about query folding when using the FHIR connector, see FHIR query folding.

Set up your connection in a pipeline

Data Factory in Microsoft Fabric doesn't currently support FHIR in pipelines.

Related content

  • Last updated on