Forum Discussion
Pmorg-73
Helper I
1 year agoHow to solve Query Parameter error?
Hi I have not had this message before. And it is not very helpful tbh. I had started to get refresh errors on a scheduled refresh and Ifind one of my queries would not refresh in the desktop....
- 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
davidkofodhanna
Advocate I
1 year agoHi there,
One idea could be to explore the Query Diagnostics in Power Query.
See link here: https://learn.microsoft.com/en-us/power-query/query-diagnostics