The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Hi @jzfhir ,
This is the related document, you can view this content:
Power Query connector for FHIR - Power Query | Microsoft Learn
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.