Use DAX Output to generate parameters for Power Query like you can with Excel tables?

Thank you very much for that reference.  I have not tried that and will definitely go through the details you provided - that is more or less exactly what I was looking for (and it also provides the added potential for a user to select values - which I am sure will come up sooner or later as well).  

I believe that I previously used a similar solution to access the Power BI Data Model from Excel so that I could generate basic pivotable output from a Power BI solution (I believe that I found that data on your site and I provided a PowerShell script to identify the Power BI system ID).  I should have remembered to check your site!  This is incredibly helpful, hopefully I can make it work for my data model.

I hope that the Power BI developers will consider enabling this type of solution through the query parameter process at some point in the future.  Having to reload massive files through Power Query versus manage more efficient options to group/categorize data with DAX to use as parameters for other queries is a significant limitation in cases when the luxury of a backend database source for some of the large files you are dealing managing.