Forum Discussion
Cannot find Bind to Parameter Option
Your table is in import mode.
Hi,lbendlin ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,Anonymous .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 LearnI hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
Your table is in import mode.
Do these work with stored procedures or only with tables and views in direct query mode?
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
