FHIR Connector: Retrieving Primitive Data Extensions

[jzfhir]

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?

[Anonymous]

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.