Dynamic M query parameters in Power BI Desktop[Bind to parameter]

[hisupermodel]

Hello everyone,

Now  I am following this guide to test something.

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

In that guide, step 9 & 10, about Bind to parameter . I don't found this field in properties. 

so I don't know the reason, why couldn't see the Bind to parameter field？ Is there something wrong in my setting?

[amitchandak]

@hisupermodel , is it a direct query source with supported databases? This is supported only on limited dataabse

[hisupermodel]

Thanks for your reply. 

Currently I use the datasource is Excel. I see the video introduction (https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters). It said that "M query parameters support more data soures".

I think even if the data source only supports for database, so when I used EXCEL, in the properties i should also see the Bind to parameter option. It's just not available. It is weird.