Forum Discussion
How to solve Query Parameter error?
- 1 year ago
Hi Pmorg-73 ,
It is telling you which parameter to look at: Parameter12.
In Power Query, go to the Home tab > Manage Parameters and all your parameters should be listed here:
It looks like you have a parameter that, for whatever reason, isn't getting populated before you're trying to refresh. It may be the result of another query that isn't refreshing in time before the main query requires it, but difficult to say from here, I'm afraid.
Pete
ahaaaaa. So......... It was a parameter being used for a table I had recently deleted as I no longer need it. Must remember from now on to delete the qery it leaves behind. I assume it was looking for a table in my sharepoint folder that I had then deleted as well. Thanks for the help guys
No problem, happy to help.
Don't forget to give a thumbs-up on any posts that have helped you 👍
Pete