Forum Discussion

Coriel-11's avatar
Coriel-11
Icon for Resolver II rankResolver II
4 years ago
Solved

Dynamic M query parameters checkbox not showing in Options

Hi, I'm trying to use Dynamic M query parameters but am falling at the first hurdle*. When I go to  File>Options and Settings>Options in Desktop, I'm not seeing the check box for "Dynamic M query pa...
Need Help
  • Coriel-11's avatar
    Coriel-11
    4 years ago

    I eventually got to the bottom of this. There were 2 issues here:

     

    1- This functionality only works with DirectQuery sources. If you're just wanting to pick a complicated Excel file from a SharePoint folder of identically laid out Excel/CSV files you can't do it.


    2- If you are using a DirectQuery then this feature became "generally available" in the April 2022. Once this happens it no longer appears under File>Options and Settings>Options>Preview Features. This is the reason I couldn't even see the check box, which threw me off the scent (hence why I thought it might be down to our set-up).

  • Coriel-11's avatar
    Coriel-11
    Icon for Resolver II rankResolver II
    4 years ago

    Thank you v-xiaotang.

    That page (& its video) was actually one of the places I first started out and I suppose in a way it does contain the answer to my problem, but it also led me on a bit of a wild goose chase.

     

    I came to it because I was trying to find a more user-friendly way of being able to change parameters in desktop when differing excel &/or csv files are bring pulled into Power Query. I use parameters all the time, but changing them is not straight fprward for non-techie people who don't otherwise use Power BI.

     

    This seemed like the perfect solution, but, I eventually realised, it only works for DirectQuery sources. Moreover since this feature became generally available in the April 2022 (and once a feature "becomes generally available" it no longer appears under File>Options and Settings>Options>Preview Features) I couldn't even see the check box under File>Options and Settings>Options>Preview Features, so that threw me off for a bit.

     

    Do you if there's a good reason why this functionality doesn't work for simpler sources? It would really be useful and it seems a bit odd you can't use for most of the common types of source regardless of whether they are dynamic.

    Thanks,

    Coriel.