Cannot find Bind to Parameter Option

[divyamannava]

Checked all the conditions type of parameter and the data is same 

and the table is a direct query and couldnt the Mquery check and as perresearch that was made defaualt in the new versions so couldnt find it and for the data source i am using odbc connector

[lbendlin · Accepted solution]

Your table is in import mode.

[Anonymous · Accepted solution]

Hi,lbendlin ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@divyamannava .I am glad to help you.
As suggested by lbendlin, you need to reconnect to the data source and change the connection to Direct Query mode.

You can see that this option is not available in import connection mode, whereas it is available in Direct query connection mode.

I hope that the following examples will help you.
Make sure the connection mode is Direct Query
and the parameters are set correctly.
Solved: Power BI - Bind column to Parameter - Microsoft Fabric Community
Solved: Bind to parameter is missing in modelling advanced... - Microsoft Fabric Community
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[lbendlin · Accepted solution]

Your table is in import mode.

[sasdfasdfsad]

Do these work with stored procedures or only with tables and views in direct query mode?

[lbendlin]

That depends on your masquerading skills.  Power Query doesn't know the difference between a table, a view , or anything else that returns a usable value (doesn't even have to be tabular until the very end)

Read about Value.NativeQuery and EnableFolding . Query folding on native queries - Power Query | Microsoft Learn