Using EQuIS Data in Power BI

<< Click to Display Table of Contents >>

Using EQuIS Data in Power BI

Once the user is authenticated, the Power BI Navigator window opens with the Enterprise URL as a node in the folder tree. Facility Groups, Facilities, and a Reports folders will be available. The facilities and reports contained in these folders are based on user permissions. The Reports folder will only contain user reports that are not associated with a specific facility.

PBI_PowerBI-Navigator_Cropped

Click on the Facilities or Facility Groups folder node to display all facilities to which the user has permissions. Select the desired facility. Within the folder for each facility will be a Reports folder and a Locations table.

 

Select the Locations table for the selected facility. A preview of the locations will be displayed in the Preview Pane on the right. Check the Locations table to be able load the locations into Power BI.

PBI_PowerBI-Navigator_GKM_Locations

Click on the Reports folder node to display all user reports associated with the selected facility. Select the desired report. A preview of the report data will be displayed in the Preview Pane on the right. Check the Report to be able load the report data into Power BI.

PBI_PowerBI-Navigator_GKM_Report

After all desired locations and/or user reports are checked, click the Load button to load the EQuIS data into Power BI. The EQuIS data will be available as Fields in Power BI for data analysis and visualization.

PBI_PowerBI_GKM_Fields

PBI_PowerBI_GKM_Fields_Table

Refer to Microsoft Power BI help for information pertaining to the various tools available in Power BI for data analysis and visualization.