Forum Discussion

Pmorg-73's avatar
Pmorg-73
Icon for Helper I rankHelper I
1 year ago
Solved

How 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....
  • BA_Pete's avatar
    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