Bind to Parameter missing from Advanced options

Hi Anonymous ,

Are you using DirectQuery connection mode ?

As a prerequisite for this feature, you must have a valid M Query Parameter created and referred in one or more Direct Query tables.

For more information, please refer to: Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs

As you mentioned "I have not been able to get the "Bind to Parameter" option to show up under the Advanced options", in the current known issue, some users can't find "Bind to Parameter" option when they reopen the pbix file. Did you have the same problem as them?

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.