Visualize and share your Insightly CRM data in Power BI with the Insightly content pack. Connect to Power BI using your Insightly API key to view and build reports and dashboards from your CRM data. With Power BI, you can analyze your data in new ways, create powerful graphs and charts, and display contacts, leads, and organizations on a map.

Connect to the Insightly content pack for Power BI.

How to connect

  1. Select Get Data at the bottom of the left navigation pane.

  2. In the Services box, select Get.

  3. Select Insightly >  Get.

  4. Select Key as the Authentication type and provide your Insight API Key then select Sign In. See details on finding this below.

  5. After approving, the import process will begin automatically. When complete, a new dashboard, report and model will appear in the Navigation Pane. Select the dashboard to view your imported data.

     

What Now?

What's included

The content pack includes the following tables with fields from the corresponding records:

Tables
Contacts Opportunities Pipeline Stages Task Complete Date
Custom Fields Opportunity Close Date Project Complete Date Tasks
Events Opportunity Forecast Date Projects Teams/Members
Leads Organizations Tags Users

Many tables and reports also include unique calculated fields, such as:
- Tables with “grouped” opportunity forecast close dates, opportunity actual close dates, project completion dates, and task completion dates for analysis by month, quarter, or year.
- A weighted value field for opportunities (opportunity value * probability of winning).
- Average and total duration fields for tasks, based on start and completed dates.
- Reports with calculated fields for opportunity win rate (count of won/count of total opportunities) and win rate value (value of won/value of total opportunities).

System requirements

An Insightly account with access to the Insightly API is required. Visibility permissions will be based on the API key used to establish the connection to Power BI. Any Insightly records visible to you will also be visible in the Power BI reports and dashboards that you share with others.

Finding parameters

API Key

To copy your API key from Insightly, select User Settings from the Insightly profile menu and scroll down. This string of characters will be used to connect your data to Power BI.

Troubleshooting

Your data is imported via the Insightly API, which includes a daily limit based on your Insightly subscription plan level. The limits are listed in the Rate Limiting/Throttling Requests section of our API documentation: https://api.insight.ly/v2.2/Help#!/Overview/Introduction#ratelimit

The provided reports use default fields from Insightly and may not include your customizations. Edit the report to view all the available fields.

See also

Get started in Power BI

Get data in Power BI