Using EQuIS Data in Power BI
Copyright © 2019 EarthSoft, Inc • Modified: 12 Nov 2019
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.
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.
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.
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.
Refer to Microsoft Power BI help for information pertaining to the various tools available in Power BI for data analysis and visualization.