Power Query Data Refresher Pro
Rating
0
Reviews
0
App details
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:
- Detect all the xlsx files in that folder
- Detect all the source locations referenced by each file’s Power Query M-Code
- Determin the dependencies in all the excel spreadsheets so each item is only refreshed once
- Log the number of rows extracted for each refresh
- 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