add ETL-features to ACCESS (retry of: Add PowerQuery to ACCESS)
I still do thoroughly hope, you will integrate ETL-features to Access!
In EXCEL as well as in PowerBI you can use "retrieve and transform data" to collect data from diffent sources.
I don't want to write back data to the sources.
Many of my clients - financial controllers and data analysts - use ACCESS as a kind of datamart for their reporting, as I wrote in my BLOG "controllingexcellent". They collect data from different source, mostly TXT-files, CSV, Web, EXCEL-Files and Databases at the same time.
It is the "single source of truth" where data is stored. Many other reports in EXCEL or PowerBi receive data from this single source, where all data has the same relevance.
Here it is also possible to update just part of the data, without re-loading those parts loaded previously. Timestands help to control the topicality of the updates.
I don't see any competion between EXCEL an ACCESS, I think each should be used, for what it does best. ACCESS stores data.