Stream: storage for FHIR
Topic: BI on FHIR
Andy Sanchez (Mar 07 2019 at 20:42):
Hi. I am working on a project in which there are two SQL databases in Azure, one to concentrate data from several external systems with a bit of preprocessing and another that is dimensionally modeled to facilitate the analysis of the business, which It consumes the data directly from the first database. The entire ETL process is being carried out through Azure Data Factory. Finally, Power BI is used to create different reports according to the needs of the business having as source the second database.
The problem is that now the external systems that had their data in SQL relational databases are now migrating to FHIR servers, which means that the ETL process changes completely as does the structure of our databases. On the other hand, Power BI, which is the data analysis tool that we must use, does not yet have integration with FHIR. I would like to know under these conditions and taking into account that we consider the performance important, which are the edges that are currently being used in these cases. Maybe if you know some references that can help us would be great.
Richard Stanley (Mar 08 2019 at 13:45):
I’d suggest an intermediate format like FHIR in ndjson but last time I tried it Power BI didn’t parse it on import. Azure SQL appears to have json support as strings which you could use to store FHIR then query. It’s not as elegant as FHIRbase which uses binary blobs but just a test. Sorry if those suggestions are not helpful.
Andy Sanchez (Mar 08 2019 at 18:44):
Thanks Richard
Geoff Williams (Mar 20 2020 at 19:07):
PowerBI desktop now has a FHIR connector. I tested with MS FHIR API so it might work.
Last updated: Apr 12 2022 at 19:14 UTC
