Import Historian Data into Power BI Desktop

About this task

Microsoft Power BI Desktop is an application that transforms and visualizes data. Using this application, you can connect to multiple data sources and combine the data into a data model.

This topic describes how to import Historian data into Power BI Desktop.

Procedure

  1. Access Power BI Desktop.
  2. Select Get Data > Other > OLE DB, and then select Connect.
    The From OLE DB window appears.
  3. Select Build.
    The Data Link Properties window appears, displaying a list of the Historian OLE DB providers in the Provider section.
  4. Select Next.
    The Connection section appears.
  5. Leave the default values as is, and select Test Connection.
    After the connection succeeds, the connection string is populated in the From OLE DB window.
    Important: Do not use the connection string that is populated. If you do so, an error occurs.
  6. Change the connection string to Provider=iHOLEDB.iHistorian.1;PersistSecurity Info=False; USER ID=[<Historian server username>]; Password=[<Historian server password>]; Data Source=[<NLB DNS>]
  7. Select OK.
    The OLE DB Provider window appears.
  8. In the Database section, enter ihCloudHistAdmin as the username, and enter the password that you provided in the Proficy Authentication Configuration field while deploying Proficy Historian for AWS, and then select Connect.
    A list of Historian tables appears in the Navigator section.
    If an error message appears after entering the credentials, restart your machine.
  9. Select the table whose data you want to import, and then select Load.
  10. Select .
    Data from the selected Historian table appears.

What to do next

You can now create a Power BI report and then publish it.