Using Microsoft Power BI to analyze your Replicon data

Three types of connectors are available for connecting to your Replicon data using Microsoft Power BI, where you can view and build charts based on that data.

• Sample dashboards use sample Replicon data to show you what Microsoft Power BI can do
• Template dashboards use your organization’s data as the source and starting point for sample charts
• Replicon’s connector for Microsoft Power BI allows you to create charts from scratch. Try this option if you don’t need the examples from the sample dashboards.

Refer to Gaining business intelligence using your Replicon data for more information on these connection options, and about other methods of analyzing your data.

All of these options are supported for use with the desktop version of Power BI. They should also work with other editions of Power BI, though their use with other editions hasn’t yet been tested.

When you use a connector, users only see data that they have permission to view in the rest of the Replicon application.

Viewing demo dashboards

To help you get started with analyzing your data, we’ve set up a demo dashboard in Microsoft Power BI you can use. It can give you an idea of what you can do with Replicon data using Power BI.

Currently, we offer a dashboard for project analytics, called the ProjectTime dashboard. It shows sample time tracking, utilization, productivity, project, and time off charts, and can be used with any Replicon instance with project functionality.

To view a demo dashboard:

1. Launch Power BI.
2. Go to File > Options and Settings > Options.

3. Then select Security, and in the Data Extensions section enable the (Not Recommended) Allow any extension to load without validation or warning option, and click OK.

4. Close Power BI.
5. Click the link below to download the sample dashboard zip file:

• • ProjectTime dashboard file

6. Double-click the downloaded file.

Viewing your Replicon data in template dashboards

Use template dashboards to see the sample charts from the demo dashboards populated with your organization’s Replicon data. You can use these charts as they are, or use them as a starting point for your own custom graphs.

To use your Replicon data in the charts:

A. Download connector file and save it to the designated location

1. Create this directory on your machine:

2. Download the Replicon connector file and copy it to the directory you just created.
3. If Power BI is open, close it.

B. Download and launch the sample data file

1. Download the sample data zip file:
   • ProjectTime sample data file
   • TimeBill sample data file
2. Unzip the file, and launch the .pbit template file.

C. Authenticate to gain access to your Replicon data

1. Click Sign in.

2. Enter the company name you use to log in to your Replicon instance, and click Next.

2. Enter your user name and password, and click Login.

3. You’ll see a message stating you’re signed in. Click Connect.

D. Refresh and save dashboards

1. If you want to see changes you’ve made to your data in Replicon reflected in the charts, click Refresh.

2. Click File > Save As, and choose a name and location for a .pbix version of the workbook.

The charts look strange when using my company’s data

The sample data charts are optimized for the sample data source. Therefore, when you switch to using your own data, some of the charts may not look quite right. Common causes for this include:

• Your filter date range doesn’t include any data
  The sample data is filtered for 2018 by default; you may have to adjust the date range to see meaningful visuals if you don’t have much 2018 data.

• You don’t have data for a parameter used in the graph
  For example, some customers don’t track costs, only hours. In this case, charts filtered by cost won’t look right. To fix this issue, you can switch to filter data by hours.

I see an error instead of a chart

If you see an error in place of a chart (for example, Error: Unknown table ‘CostItem’), this means you don’t have access to the data needed to populate that chart.

For instance, you may not have the necessary products assigned, or you may not have permission to view that data.

Connecting using Replicon’s connector for Microsoft Power BI

When you use our native connector to connect to Microsoft Power BI, your data source is our Replicon API for BI Services.

Once connected, you’ll be able to access most Replicon data tables, and create visual representations of that data from scratch using Power BI.

To connect:

A. Set Power BI security settings to allow connection

1. Launch Power BI.
2. Go to File > Options and Settings > Options.

3. Close Power BI.

B. Download connector file and save it to the designated location

1. Create this directory on your machine:

2. Download the Replicon connector file and copy it to the directory you just created.

C. Launch the connector

1. Re-launch Power BI.
2. Click Get Data.

3. Enter Replicon in the search field.

4. Select the file name, and click Connect.

5. Click Continue.

D. Authenticate to gain access to your Replicon data.

1. Click Sign in.

2. Enter the company name you use to log in to your Replicon instance, and click Next.

3. Enter your user name and password, and click Login.

4. You’ll see a message stating you’re signed in. Click Connect.

E. Import your Replicon data into Power BI

1. Double-click a data set to view the available data tables. Enable the check boxes beside each table you want to work with. Then click Load.

2. A Connection Settings dialog displays, asking you to choose how to access the tables you selected.