Automating Lists Snapshot using Power Automate: Part 2 – Integration with Power BI

by | Mar 15, 2025 | Don Kang, The Data School, Uncategorized

Continued from Part 1 – MS Lists Snapshot using Power Automate

In Part 1, we covered how to capture snapshots of Microsoft Lists using Power Automate. By the end of that process, we had a series of snapshot data files stored in a SharePoint folder. Now, with these snapshots, we can build timeline visuals and analyze trends over time.

Automating Lists Snapshot using Power Automate: Part 2 – Integration with Power BI

Step 7: Import Snapshots into Power BI

  1. Open Power BI and use Power Query to load data.
  2. Set the Source to the folder containing the snapshot CSV files. 
  3. (Optional) Apply filters based on File Extension or File Name Contains to limit the dataset. 

Step 8: Analyze Snapshot Data

  1. In Power BI, review the dataset to see multiple snapshots differentiated by timestamp. 
  2. Use filters to analyze data at a specific point in time.

     

  3. Create visualizations to track timeline trends based on snapshot data.

     

By following this structured process, you can automate the extraction, storage, and analysis of Microsoft List snapshots efficiently.

 

Don Kang
Author: Don Kang

Experienced Engineer with a diverse background in academic research and engineering seeking for a career transition to data and AI engineer. Skilled in Python, SQL, Alteryx, Tableau, Power BI and cloud platforms such as, GCP, AWS and AZURE. Detail-oriented and quick to adapt to evolving business needs and industry trends, with a passion for leveraging data to drive decision making and innovation.