Data Import & Export

How to Import Excel Change-Log Data into Power BI

Muhammad Talha Oct 9, 2026 869 views

Question details

The user needs to import historical change-log information, such as timestamps, changed values, and user names from an Excel file, into Power BI to track data modifications over time.

How to Import Excel Change-Log Data into Power BI

Product: Excel, Power BI
Device & OS: not provided
Scenario: Visualizing changes over time in an Excel workbook using Power BI.
Observed behavior: Power BI only connects to the current state of Excel tables and does not automatically extract or import native Excel version history or change-log metadata.

Before you start

Ensure your Excel workbook is stored in a supported cloud location like OneDrive for Business or SharePoint, which allows Power BI to easily refresh your dataset once the connection is established.

Solution 1Recommended

Create and Load a Structured History Table in Excel

Since Power BI cannot automatically pull Excel's native version history, you must maintain a dedicated, structured table inside your workbook to record changes manually or via macros before importing it.

Power BI datasets do not include file metadata such as document version history or system change logs. To get this data into Power BI, the history must exist as actual row data inside a standard Excel table.

Set up the history table

Open your Excel workbook and create a new worksheet. Set up column headers for your change log, such as 'Record ID', 'Timestamp', 'User Name', 'Original Value', and 'Changed Value'.

Log your data changes

Whenever a record is updated in your main dataset, add a new row to this history table detailing what changed and when. This can be done manually or automated using Excel VBA scripts.

Format as an Excel Table

Select your range of historical data, go to the 'Insert' tab, and click 'Table' (or press Ctrl+T). Give the table a recognizable name like 'ChangeLogTable'.

Connect to Power BI

Open Power BI Desktop, click 'Get Data', and select 'Excel workbook'. Navigate to your saved file in SharePoint or OneDrive, select 'ChangeLogTable' from the Navigator window, and click 'Load'.

Create and Load a Structured History Table in Excel

Data Visualization Ready: Structuring your data this way allows Power BI to effectively visualize historical trends, build timelines, and track specific user modifications over time.

Prepare Power BI Change-Log Data with WPS Spreadsheet

You can easily create, format, and manage the required structured history tables for Power BI using WPS Spreadsheet. It provides a lightweight, efficient environment to handle your data preparation before visualization.

1. Open a new workbook: Launch WPS Spreadsheet and create a new blank workbook to serve as your history database.
2. Define your columns: Set up essential tracking columns: Timestamp, Modified By, Field Changed, and New Value.
3. Enter your historical data: Input or copy your historical change data into these columns to build a comprehensive log.
4. Save as XLSX: Go to 'Menu' > 'Save As' and choose the '.xlsx' format to ensure full compatibility with Power BI.
5. Import into Power BI: Open Power BI Desktop, use the 'Get Data' feature, and select your newly created WPS Spreadsheet file to load the change log.

Easily structure change-log and history tables for Power BI importFully compatible with Microsoft Excel (.xlsx) formatsFamiliar interface with zero learning curve for rapid data entryLightweight and free alternative for daily data preparation tasks

microsoft office alternative - wps office

Frequently Asked Questions

Can Power BI extract version history directly from SharePoint?

No, Power BI only imports the current row data within the tables of your Excel file. Native SharePoint or OneDrive version history metadata cannot be automatically converted into Power BI table data.

What columns should my Excel change-log table include?

For effective tracking and filtering in Power BI, you should include columns for a unique identifier (Record ID), Timestamp (Date/Time), User Name (who made the change), Old Value, and New Value.

Does Power BI automatically refresh the Excel change log once imported?

Yes, if your Excel file is stored in a supported cloud location like OneDrive for Business or SharePoint, you can schedule automatic dataset refreshes in the Power BI Service to pull in any newly added change-log rows.

Excel & Data Problems