Power BI Dashboard for FHIR Server
In this blog, we will show how to connect PowerBI Service to a FHIR server and create Power BI dashboard. Power BI FHIR Dashboards are built using PowerBI connector for FHIR with focus on Patient, Clinical and Claims resources of FHIR.
- Patients- Patient demographic distribution, patient encounters, patient LOS and related information
- Clinical – Active and resolved conditions, distribution of patients to conditions, distribution of observation category to encounters etc.
- Claims – Distribution of claims value to Insurer, to city, by age, by claim type etc.
- Open Power BI Desktop
- Click on Get data
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/1.png)
- On the New window, Type and search ‘FHIR’. Select ‘FHIR’ shown under ‘All’ and click Connect at the bottom.
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/crop-0-0-532-579-0-Picture2.png)
- Another window will open, Enter following URL ‘https://r4.smarthealthit.org/’, which has data related to FHIR entities. Click OK
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture3.png)
- If asked for authentication, make sure ‘Anonymous’ is selected and then click ‘Connect’.
- On successful connection, a ‘Navigator’ window will come up.
Select required tables from the list of tables on the left and Click ‘Transform Data’
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture4.png)
- Power Query Editor Window will open. Here we have to do all the cleaning up (expanding hierarchy, renaming columns etc) of data.
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture5.png)
- Next click on ‘Close & Apply’, another window will pop up showing data load for all the tables
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture6.png)
- In the report tab, under ‘Field’, all the tables loaded and transformed will be listed.
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture7.png)
- Click on Model tab, create relationship between tables using the ‘drag and connect’ feature for related columns.
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture8.png)
- Once the relationship among all the table are defined, next step is to create required visuals for each report.
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture9.png)
- Click on Publish to Publish the report to the desired workspace.
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture10.png)
- Once Publish to desired workspace, report is available for users to explore in Power BI Service
![](https://7b67ba.a2cdn1.secureserver.net/wp-content/uploads/2021/05/Picture11.png)
In our next blog we will cover few more FHIR resources. For any assistance with building PowerBI reports and dashboard on FHIR repository please contact us by filling out Contact form.