Import Historian Data into Power BI Desktop
About this task
This topic describes how to import Historian data into Power BI Desktop.
Procedure
- Access Power BI Desktop.
-
Select Connect.
, and then select The From OLE DB window appears.
-
Select Build.
The Data Link Properties window appears, displaying a list of the Historian OLE DB providers in the Provider section.
-
Select Next.
The Connection section appears.
-
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.
-
Change the connection string to
provider="ihOLEDB.iHistorian.1";mode=Read
-
Select OK.
The OLE DB Provider window appears.
-
In the Database section, enter the credentials to connect
to the Historian server, and then select Connect.A list of Historian table appears in the Navigator section.If an error message appears after entering the credentials, restart your machine.
- Select the table whose data you want to import, and then select Load.
-
Select
.
Data from the selected Historian table appears.