How to Connect Power BI to Live Proficy Historian Data in Excel
Question details
The user wants to connect Power BI to an Excel file that contains live data retrieved from Proficy Historian.
- Product
- Power BI and Excel
- Device & OS
- not provided
- Scenario
- Retrieving and visualizing live industrial data by linking Power BI to an intermediate Excel file that is connected to Proficy Historian.
- Observed behavior
- Seeking a reliable method and configuration to ensure the data connection between Proficy Historian, Excel, and Power BI is supported and refreshable.
Ensure that your Excel file is saved in a supported format like .xlsx and that the Proficy Historian provider or add-in is properly configured to allow external data refreshes.
Verify Data Connections and Import to Power BI
Ensure the Excel file has refreshable data connections enabled before importing it into Power BI Desktop.
To make sure Power BI can fetch the latest records, the Excel workbook must be configured to refresh its Proficy Historian data connection properly. Power BI will read the data stored in the Excel file at the time of import or refresh.
Open the Excel file containing the Proficy Historian data. Navigate to the Data tab and click on 'Queries & Connections' to verify the data source.
Right-click your Proficy connection, select 'Properties', and ensure the connection is set to refresh data automatically (e.g., refresh on open or at specific intervals).
Open Power BI Desktop, click 'Get Data' from the Home ribbon, and select 'Excel Workbook'.
Locate and select your Excel file, check the specific sheets or tables containing the live data in the Navigator window, and click 'Load'.
Consult the Power BI Community for Advanced Setup
Since Proficy Historian integrations can require specific OLE DB/ODBC drivers and gateway configurations, reaching out to specialists can resolve complex refresh issues.
Prepare Your Data Seamlessly with WPS Office
While live connections to industrial databases like Proficy Historian are handled via specialized add-ins and tools, preparing and managing your exported data files is effortless with WPS Office. As a free, lightweight alternative, WPS Spreadsheet offers exceptional compatibility for formatting data before ingesting it into visualization platforms.
- 1. Open WPS Spreadsheet: Launch WPS Office and open the Spreadsheet application.
- 2. Format Your Dataset: Import your raw industrial data and use built-in formatting tools to organize it into clean, standardized tables.
- 3. Save for Visualization: Save the organized document as a standard .xlsx file, ready to be loaded into your preferred data visualization tool.
Frequently Asked Questions
Can Power BI connect directly to Proficy Historian without using Excel?
Yes, it is often possible to connect Power BI directly to Proficy Historian using an OLE DB or ODBC connector if the correct drivers are installed on your machine. This method generally provides a more reliable live-refresh experience than routing through an Excel file.
Why isn't my Proficy data refreshing in the Power BI Service?
If you are using an Excel file as an intermediary, Power BI Service requires the Excel file itself to be updated and accessible. For automated cloud refreshes, you typically need to configure an On-premises Data Gateway equipped with the appropriate Proficy drivers.
Do I need a special add-in to pull Proficy data into an Excel spreadsheet?
Yes, retrieving live data typically requires installing the Proficy Historian Excel Add-in or setting up a specific external OLE DB/ODBC data connection within your spreadsheet software.
