Ian had to troubleshoot a Bad Parameter in refreshable Excel report query. He was kind enough to explain his process.
— Read on www.azurecurve.co.uk/2020/06/bad-parameter-in-refreshable-excel-report-query/
Bad Parameter in refreshable Excel report query – azurecurve
Archived post from 2020. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.