How To Export Data From the FO&M Dashboard

This guide provides a straightforward, step-by-step process for exporting data from the FO&M Dashboard, making it a valuable resource for users seeking to efficiently manage and utilize their data. By following the outlined instructions, users can easily retrieve specific datasets.

Jennifer Fullerton
12 steps
2 minutes

Dartmouth

Microsoft Power BI

Navigate to [Facilities.Dartmouth.edu](http://toFacilities.Dartmouth.edu)

Click "FO&M Supervisors"

Click "FO&M dashboard"

Set your desired view using filters for which you want to export data. Right click on a data point to drill through to the Order Details (in this example we used the data from Priority-4 Open Orders)

Click "Drill through" on the drop down list

Click "Order Details"

When you arrive to the data set, click on the button with three dots that shows at the top right of your data grid

Click "Export data"

Choose how you want to export your data

Selecting "Data with current layout" will export the data into an excel spreadsheet, keeping the same information along with the same layout

Selecting "Summarized Data" will allow you to export the data in .xlsx form, or .csv format. Here is the data in an excel spreadsheet.

Click "Export"