>

Fit can export data in two forms for use with Power Bi Reporting.

#### CSV export

A CSV export can be accessed from the Admin Export menu or the options side menu of reports.

This can then be imported as a Data Source into Power Bi: Data Source : File -> Text/CSV

The following CSV example uses a simple export from FIT and creates the following three visualizations :

- Stacked Bar Chart comparing Project and Status on axes
- Pie Chart comparing Status as values
- Table Chart showing desired columns

#### REST Api Web Source

As a web data source can be created through a REST API call to FIT, which is outlined below. This web option allows for updated information in real time, where the csv option require updates to the data source.

Power Bi offers a "Web" option to retrieve data for visualizations. This requires a URL for the basic URL option which, will look like the following (using minimal options from FIT) :

https://my.domain.com/restapi/fitapp/getBugList?CONTEXT=0&login=user&actualFieldLabels=on

This url requires that the REST API is enabled and can be used with a number of options depending on if you want to minimize the data being retrieved. A Web URL Generator is available below to help create/test the URL with various options.

The following Web example uses the following API call from our Risk Manager demo :

getBugList?CONTEXT=0&rand=1234&loginid=admin&password=admin123&actualFieldLabels
After removing unnecessary fields, the following three visualization were created

- Pie Chart comparing Projects as values
- A Table Chart showing desired columns
- A Synoptic Panel (downloaded visual) showing Risk Index Counts over a matrix backdrop

## Web URL Generator

##

Context: |
Loginid: |
Password: |
actualFieldLabels: |  | Use actual field labels instead of internal class names (more meaningful field names)

##

Show History: |  | **optional, overrides bugHistory in Column
offset: |  | **optional (start result list at given offset)
groupSize: |  | ** return a maximum group size (from offset). defaults to user profile groupSize (<0 or blank will return all items)
showFieldInfo: |  | ** show a mapping for internal ids to field labels

##

You can request specific fields to make your criteria smaller by adding a list of field ids.

Use Columns From Report ID |

Alternatively, Add a comma delimited field id list.
( Example: 1,2,101 to show Id, Subject and custom field1 ) (add 100 for custom fields)

Specific Fields: |  |

##

You can filter your results by adding filter criteria or passing the id of a saved filter

Use Filter Criteria from Report ID: |

WEB URL:
Test Result: