Power Query Data Refresher Pro

Power Query Data Refresher Pro

Rating
0
Reviews
0
Power Query Data Refresher Pro
Power Query Data Refresher Pro
Power Query Data Refresher Pro
Power Query Data Refresher Pro

App details

Release date

2021-09-09

Last update

2022-03-11

Product ID

9P8BN5NNR12D

Categories

Business

About Power Query Data Refresher Pro

Power Query Data Refresher Pro is a tool that enables you to build an ETL (Extract Transform Load) structure using Excel’s Power Query. This is a Pre-Cloud environment and will allow you to use this structure in Power BI Data Flows.

This version will allow you to determine a folder location that will:

  1. Detect all the xlsx files in that folder
  2. Detect all the source locations referenced by each file’s Power Query M-Code
  3. Determin the dependencies in all the excel spreadsheets so each item is only refreshed once
  4. Log the number of rows extracted for each refresh
  5. Detect changes since the last refresh to the M-Code and save the new version for change control (evidence and backup)

Key features

  • Scheduling
  • Change Control
  • File Logging
  • Database Logging
  • Python I tegration
  • Excel Dependency Detection
  • Autonomous Data Refresh
  • Pre-Cloud Environment
  • Local Only Environment