The ability to specify what secondary roles to use towards snowflake

Currently when working with Power BI towards Snowflakes, the options are quite limited. Snowflake prides itself with the way roles are used for accessing data, and not being able to select what roles to be using within Power BI severely limits our ability to use said roles properly.

Currently we can select what 1 role to be using, and we can in snowflake select our specific user to be using ALL or NONE secondary roles as default if nothing is selected. It would be better if we were able to specify what secondary roles (Plural) are to be used in conjunction with the primary role. Sometimes you have Access Policies dictating that you have access to only a subset of data in a view or an table, but when you have several roles you have access to more data, this is where the oppurtunity to select secondary roles becomes important. Ie, instead of making an connection where ALL secondary roles are used, selecting the specific roles that you actually need for the dataset or flow is more inline with best practices.

So - in the advanced connection settings I would ask that "Specify a text value to use as secondary role name (comma separated for several, optional)" is added.

This will remove some limitations that we currently have, as the only workaround right now is having default secondary roles as ALL, which is not great.