Forum Discussion
import multiple access queries from network locationns
Hi The company i work for have (for each user) an Access database application that is stored on their desktops (which is stored in a cluster storage location). How can I import the queries fr...
Everything you do in the query editor of Power BI can be turned into a function and thereby be applied multiple times. So if you create a table containing all the source paths of your databases, you can perform (the same) import-procedures on them.
For an example see: http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/
I have never worked with Access-import, but very much doubt that reports can be imported.