Forum Discussion
Post ProdigyPowr query editor - change path same file
To build a query, a person look at the source of the data and the required output to build a transformation. No one (to my knowledge) can look at vba code and build a query. I can only tell that the macro is opening several excel workbooks, picking certain fields and then copy pasting the data into a destination workbook. This process is pretty simple by selecting the From Folder option in Power query.
You would then need to modify the resulting sample query to pull in only the fields that you need and load to the Data model. All of this is quite simple to build if you have access to the data sources and are at least an intermediate Power Query user. If you are system saavy and want to learn the tool, then you could try it out. If not, you should probably hire someone to setup the query and the architecture.
Post Prodigyhi Anonymous , so what is the solution here ? can you share the code ?
Thanks,
To build a query, a person look at the source of the data and the required output to build a transformation. No one (to my knowledge) can look at vba code and build a query. I can only tell that the macro is opening several excel workbooks, picking certain fields and then copy pasting the data into a destination workbook. This process is pretty simple by selecting the From Folder option in Power query.
You would then need to modify the resulting sample query to pull in only the fields that you need and load to the Data model. All of this is quite simple to build if you have access to the data sources and are at least an intermediate Power Query user. If you are system saavy and want to learn the tool, then you could try it out. If not, you should probably hire someone to setup the query and the architecture.