Direct Query Parameters using Slicer

[gtraub]

There is a new feature for using a slicer to update a parameter that is then can be used to as part of a direct query, where clause for example, in Power Query advanced editor. It doesnt appear that this feature works with server information like in the example below.

Thought?

Thnaks, Gary

[amitchandak]

@gtraub , Are you taking Dynamic M parameters ?

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/

[gtraub]

Yes, but apparently they cant be used to change a server name in the M code.