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

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

Thanks guys

 

I had not seen away to find where "parameter 12" was. I had named all my queries so I was at a loss how to find it. (30 odd I think). But using the tips here I have located the one that is failing so will try to debug it. I may have spotted the parameter number changing when it fails. Will see if I can repair it