Bad Parameter in refreshable Excel report query

Microsoft Dynamics GPOver the last few months, I’ve been doing work with clients on creating some refreshable Excel reports. Working on one of them, we had parameters for dates and added one for Vendor ID, which is when I encountered an error:

Excel error message

Microsoft Excel

Bad parameter type. Microsoft Excel is expecting a different ind of value than what was provided.

Continue reading “Bad Parameter in refreshable Excel report query”