Allow in desktop the parameters in order to configure the access to a dataset (live & direct query

[Bamak]

Hi 

We would like please  in desktop ,  the parameters settings in order to configure  access to a dataset (live & direct query)

Currently Query M parameter is not possible because 

1) On live connection no query m is visible , and it makes sense 

2) On DirectQuery to SSAS/dataset  no query m is visible , and it makes sense too 

For us it's  like an issue because we can't use pipelines for deployment

Because lack of  sources access  variability

We have to deploy from desktop & modify souce (Test Dataset, Prod DS)    each time 

Best regards 

Christophe

[v-lili6-msft]

hi

for parameters in direct query SSAS/dataset it is a known limitation in power bi for now.

• Parameters for database and server names are currently disabled.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

and for parameters live connection it is not support in power bi for now.

for any idea and suggestion, please submit it in power bi idea in here:

https://ideas.powerbi.com/ideas/

Regards,

Lin