Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
jzfhir
New Member

FHIR Connector: Retrieving Primitive Data Extensions

Hello,

We are using the PowerBI FHIR Connector. When getting data from our FHIR server, it retrieves data in extensions to Resources as we would expect. However, we cannot seem to access data that is stored in extensions on primitive data types. For example:

 

 

 

{
                "resourceType": "Location",
                "id": "10300002",
                "extension": [
                    {
                        "url": "https://example.com/fhir/StructureDefinition/organizational-context",
                        "valueString": "EXTERNAL"
                    }
                ],
                "name": "location",
                "_name": {
                    "extension": [
                        {
                            "url": "http://hl7.org/fhir/StructureDefinition/translation",
                            "extension": [
                                {
                                    "url": "lang",
                                    "valueCode": "en-CA"
                                },
                                {
                                    "url": "content",
                                    "valueString": "location"
                                }
                            ]
                        },
                        {
                            "url": "http://hl7.org/fhir/StructureDefinition/translation",
                            "extension": [
                                {
                                    "url": "lang",
                                    "valueCode": "fr-CA"
                                },
                                {
                                    "url": "content",
                                    "valueString": "le location"
                                }
                            ]
                        }
                    ]
                }
               
            }

 

 

 

The data in Location.extension is pulled in to PowerBI, whereas the data in Location.name.extension is not.

Is this possible using the FHIR Connector? Has anyone had any success with this?

1 REPLY 1
Anonymous
Not applicable

Hi  @jzfhir ,

 

This is the related document, you can view this content:

Power Query connector for FHIR - Power Query | Microsoft Learn

Handle Custom Data and Resources in GCP FHIR Stores | by Ajit Sonawane | Google Cloud - Community | ...

FHIR® for Research Documentation - Using the FHIR API to Access Data (mitre.github.io)

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors