Import Linear Data into the Power BI Service for Visualizations

Power BI transforms your company's data into rich visuals for you to collect and organize so you can focus on what matters to you. When paired with CData Connect AI, you get access to Linear data for visualizations, dashboards, and more. This article shows how to connect to Linear in CData Connect AI, publish a dataset from Power BI Desktop to the Power BI Service and then create reports on Linear data in the Power BI service.

Configure Linear Connectivity for Power BI Service

Connectivity to Linear from Power BI Service is made possible through CData Connect AI. To work with Linear data from Power BI Service, we start by creating and configuring a Linear connection.

1. Log into Connect AI, click Sources, and then click Add Connection

2. Select "Linear" from the Add Connection panel

3. Enter the necessary authentication properties to connect to Linear.

   You can authenticate to Linear with a personal API key or with OAuth 2.0. The API key is the simplest option for connecting with your own Linear account.

   Authenticating with an API Key

   Set the following connection properties:

   • AuthScheme: Set this to APIKey.
   • APIKey: A Linear personal API key.

   To create a personal API key, log in to Linear, open Settings > Security & access > Personal API keys, select New API key, and create it. Copy the key immediately, because Linear shows it only once.

   Authenticating with OAuth

   OAuth requires a custom OAuth application registered in Linear (Settings > API > OAuth applications), which provides the OAuthClientId and OAuthClientSecret. Two flows are supported:

   • Authorization code: Set AuthScheme to OAuth, InitiateOAuth to GETANDREFRESH, and provide OAuthClientId, OAuthClientSecret, and the CallbackURL defined in your application (e.g., http://localhost:33333). The driver opens Linear in your browser so you can grant access.
   • Client credentials: Set AuthScheme to OAuthClient and provide OAuthClientId and OAuthClientSecret. This authenticates the application itself, with no browser interaction, and suits machine-to-machine integrations.

   By default, the driver requests the read,write scopes. The driver refreshes the access token automatically when it expires.

   
4. Click Save & Test
5. Navigate to the Permissions tab in the Add Linear Connection page and update the User-based permissions.

With the connection configured, you are ready to connect to Linear data from the Power BI service.

Publish a Dataset from Power BI Desktop

Once you connect to Linear in Connect AI, you can create a dataset in Power BI desktop and publish the dataset to the Power BI service.

1. Open Power BI Desktop and click Get Data -> Online Services -> CData Connect AI and click "Connect"
2. Click "Sign in" and authenticate with your CData Connect AI account
3. After signing in, click "Connect"
4. Select tables in the Navigator dialog
5. Click Load to establish the connection to your Linear data from Power BI

6. Define any relationships between the selected entities on the Relationships tab.
7. Click Publish (from the Home menu) and select a Workspace.

Build Reports and Dashboards on Linear Data in the Power BI Service

Now that you have published a dataset to the Power BI service, you can create new reports and dashboards based on the published data:

1. Log in to PowerBI.com.
2. Click Workspaces and select a workspace.
3. Click Create and select Report.
4. Select the published dataset for the report.
5. Choose fields and visualizations to add to your report.

Live Access to Linear Data from Cloud Applications

Now you have a direct connection to live Linear data from the Power BI service. You can create more data sources and new visualizations, build reports, and more — all without replicating Linear data.

To get live data access to hundreds of SaaS, Big Data, and NoSQL sources directly from your cloud applications, sign up for a free trial of CData Connect AI.