Find relevant files & info here:
The sample workbook(s) will have dynamic queries setup to access an Epicor BAQ once the relevant details are filled in the workbook and you refresh the data.
Sample BAQ zzzEUH can be created with the provided screenshots and sample SQL from the BAQ it has a parameter to PRE filter result set if you want that route or you can use the second type and use the full dataset with an in-memory query against the table in the worksheet.
You should find everything you need to put together with what you already have. If not please let me know.