How to keep a Parameter from being seen in 'Transform Data >> Edit Parameters'

[ToddChitt]

Not sure this is a Power Query topic or Desktop, because it spans both.

I have a model with three Folder sources and many others. For each Folder source, you get a Parameter. That's just the way the wizard does it. But I also have several other parameters. When I click Transform Data >> Edit Parameters, I see *all* parameters. I would like to stop the three that are related to the Folder sources from showing up. Is this possible? I have looked through the M code for the Folder source and not sure there is a way to hack through it so that the related parameter is not needed.

Does anyone know a Power Query M hack so that the parameter is not needed?

Back story: This model will not get deployed to the service. It is being shared amoung users as sort of a 'black box' for data validation. It replaces a very manual Excel process that involved Pivot tables, Copy, Paste, 12 extra tabs and soem other steps I can't recall. Now I simply have several input data sources, with one of them being the piece of data I want to 'process and validate'. I do that with relationships, calculated columns and measures. In the end, the users do a few exports to CSV of scrubbed data. It saves on average a few hours per input file.

Thanks

[mahoneypat]

Not aware of a way to do that but another option to consider is to create a source file that contains 3 rows for your folder sources, and make it so users have read only access to that source.  You can then bring in that in a query, disable load, but use each row with {0}[ColumnName] to harvest those values instead of using parameters.

Pat