Configure Power BI to Connect to a PostgreSQL Service Gateway

FactoryTalk DataMosaix Help

Introduction

Getting Started

Prerequisites

Access FactoryTalk DataMosaix

Sign-in Prerequisites

Sign in to FactoryTalk DataMosaix

Access DataMosaix from FactoryTalk Hub

About the FactoryTalk DataMosaix User Interface

DataMosaix Home Page Header

Navigation

Quick Tips

Accessibility Support for FactoryTalk DataMosaix

Install a screen reader extension

Create Project

Create Project

Manage Access

Members

FactoryTalk DataMosaix Member Roles

View Group Capabilities

Assign Role

Edit Role

Remove Role

Assign Roles to Multiple Members

Remove Roles from Multiple Members

Roles

Prerequisites

Default Roles

Custom Role

Extractor and Application Methods

Default Roles and Capability Matrix

Create a Custom Role

Remove a Capability Group from Role

Delete Role

Duplicate Role

Capability Groups

Prerequisites

Read Timeseries data

Upload 3D Models

Default Capability Groups

Create a new Capability Group

Modify Capability

Remove Capability

Delete Capability Group

Duplicate Capability Group

Features

Enable or Disable Features

Activate Features

Deactivate Features

Applications

Register Application

Regenerate Secret for Application

Edit Application

Delete Application

Extractors

Supported Extractor Versions

Register an OPC UA Extractor

Prerequisites

Register an OPC UA Extractor

Troubleshooting the OPC UA Extractor

Register an FT Historian (OSI PI) Extractor

Prerequisites

Register an FT Historian (OSI PI) Extractor

Troubleshooting the FT Historian (OSI PI) Extractor

Register an ODBC Extractor

Prerequisites

Register an ODBC Extractor

Troubleshooting the ODBC Extractor

Register an FT Optix Connector

Prerequisites

Register an FT Optix Connector

Configuring FT Optix to connect to DataMosaix

Install FTOptix - DataMosaix Connector

Configuring FT Optix to connect to DataMosaix - Continuation

Run the Optix Project in Optix Panel Runtime

View Newly Create Assets

View Flexible Data Models

Store and Forward Data

Add Alarms and Events to a FactoryTalk Optix Connector

Download the FactoryTalk Optix Connector from PCDC

Register an Asset Framework (PI-AF) Connector

Prerequisites

Register an Asset Framework (PI-AF) Connector

Troubleshooting the Asset Framework (PI-AF) Connector

Register a Custom Extractor

Prerequisites

Register a Custom Extractor

Regenerate Secret for Extractor

Edit Extractor

Setup Data Transformation for CDF

Prerequisites

Register an Extractor

Create Transformation

Set Client Credentials for Transformation

Run Data Transformation

Delete Extractor

Asset Creation

Prerequisites

Create Assets

Tree View and List View

Edit Asset

Delete Asset

Analyze Data

Configuring Power BI to connect to a DataMosaix project

Prerequisites for Power BI Desktop

Configure the DataMosaix Power BI Connector

Setting up Power BI Service using the Power BI Gateway

Automatic data refresh of reports in Power BI Service

Troubleshooting

Configuring Grafana to connect to FactoryTalk DataMosaix

Prerequisites

Configuring Grafana to connect to FactoryTalk DataMosaix

Configuring the Settings

Configuring Tableau to connect to a DataMosaix project

Prerequisites

Supported Versions

Datasource Connection

Datasource Connection using Tableau Cloud

Datasource Connection using Tableau Desktop

Supported Tables and Schema

Supported Fields for the Assets Table

Supported Fields for the Timeseries Table

Supported Fields for the Timeseries Data Points

Supported Fields for the Sequences Table

Supported Fields for the Relationships Table

Supported Fields for the Datasets Table

Supported Fields for the Events Table

Sample Reference Tableau Dashboard and Steps to Include All the Supported Tables

Create relation in asset and timeseries table

Extend relation by custom parameterized SQL of timeseries_datapoints

Prepare Tableau parameterized sheet

Supported Queries for the Tables

Sample Queries

Configure Power BI to Connect to a PostgreSQL Service Gateway

Prerequisites

Configure Power BI to connect to a PostgreSQL Service Gateway

API Reference

What is REST API?

What is M2M?

What is OpenAPI Specification?

API Tokens (What are Access Tokens?)

How to access FactoryTalk DataMosaix APIs via Swagger UI

API Versioning

Troubleshooting

No Content Available

No Application to Display

No Data Sources to Display

Cannot view the [Add] icon to register application

Cannot view the [Add] icon to register extractor

Pipeline not found

Cannot Modify Member Roles

Extractor not working as expected or failing

Configure Power BI to Connect to a PostgreSQL Service Gateway

This section describes how to configure Power BI to connect to a PostgreSQL service gateway.

Configure Power BI to connect to a PostgreSQL Service Gateway

Provide Feedback

Have questions or feedback about this documentation? Please submit your feedback here.

Normal