FactSet

Note

This connector is owned and provided by FactSet.

Summary

Property Value
Connector FactSet icon FactSet
Products Power BI (semantic models)
Power Query Online
Release state General availability
Category Other
Authentication kinds API Key
Using FactSet Login
Data source kind FactSetAnalytics
Function Reference Documentation FactSetAnalytics.ConnectionCheck
FactSetAnalytics.Contents
FactSetAnalytics.Functions
Support link Support

Prerequisites

To start using the FactSet connector, the following prerequisite steps need to be completed.

  • Download Power BI

    • Ensure that you are using the latest version of Power BI, as the latest major update to FactSet is only available there. Any subsequent major or minor version updates will only be available by upgrading Power BI.

  • Subscription & Authentication

    • To access FactSet's data, the appropriate subscription is required. Contact your FactSet representative for more details.
    • With the subscription in place, the next step is to choose your authentication method. You can either generate an API key from the Developer Portal, or you can authenticate using the Use FactSet Login option (recommended).

Supported capabilities

  • Import

Parameters

Entry point: FactSetAnalytics.Contents

Required parameter count: 0

This function has no parameters.

Connect from Power Query Desktop

To import data using FactSet from Power Query Desktop, take the following steps:

  1. Open Power BI Desktop

    On the Power BI Desktop home page, under section "Get Data" -> "More…"

    Screenshot of the Get Data drop down box with the More option emphasized.

  2. Connect to FactSet

    Search for FactSet in the Get Data pop-up and select the FactSet connector from the right-hand list.

    Note

    This connector serves as a unified solution, incorporating all the contents from previous FactSet connectors.

    Screenshot of the Get Data dialog box with FactSet emphasized.

  3. Authentication page

    You're prompted to sign in using your FactSet credentials. Alternatively, you can enter the Username - Serial and the API key. For more instructions on setting up an API key, go to the FactSet Developer Portal.

    Screenshot of the Authentication dialog box with the FactSet Login highlighted.

  4. FactSet Navigator

    FactSet opens a Navigator with a list of all functions provided. Note that all functions might not be available depending on your subscriptions; your account team can assist with requirements for access to additional products. Navigate to and select all the desired endpoint(s). Choose Load to import the data, or select Transform Data to proceed with data transformation in the Power Query editor.

    Screenshot of the Navigator dialog box with a list of all of the provided functions.

  5. Use Functions in FactSet

    A form populates in the query window with parameter fields to guide you. You can use the Developer Portal for more detail on the types of values accepted for each parameter and detail about the responses.

  6. Result Format

    Results are returned as a table and can be used to build your visualizations.

  • تاريخ آخر تحديث في