Power Query Data Refresher
Rating
3
Reviews
1
App details
About Power Query Data Refresher
Use Power Query Data Refresher to Automate your excel refreshes. This tool will help you sepcify a folder location that you want to refresh, and will detect all the Excel Power Query Sources files. It will automatically determine the order inwhich to refresh the data and allow you to export all tabs to a specified export folder.
Key features
-
Excel Automation - Detect your file dependencies you can ensure all you data is automaticlaly included in the refresh.
-
Data Refresh - Using Microft Excelent ETL language called Power Query connect to just about anything and build excellent data transformations
-
Data Export - Use the export features to download and keep track of data changes each time data is refreshed.
-
Pre-Cloud - Enable logical sperate of transofrmation improve your re-usabilty of data transformations, which can used to build Data Flows in Power BI
-
Secure - By using your own Version of Excel, this keeps all your data in your environment
-
Fast- Use the full power of your local hard ware machines and build efficient data flows