Bind to Parameter Not Showing

[Rajagopal]

Bind to Parameter Not Showing My Data Source is MSEXCEL 

Please help me 
 How Can I find The 

"Bind to Parameter " option 

[gchiu]

It is not showing for me either in Version: 2.118.404.0 64-bit (June 2023).

[v-luwang-msft · Accepted solution]

Hi @Rajagopal ,

According to the official article, As a prerequisite for this feature, you will need to have a valid M Query Parameter created and referred in one or more Direct Query tables.

Note: The following DirectQuery sources are not supported:

• T-SQL based data sources: SQL Server, Azure SQL Database, Synapse SQL pools (aka Azure SQL Data Warehouse), and Synapse SQL OnDemand pools
• Live connect data sources: Azure Analysis Services, SQL Server Analysis Services, Power BI Datasets
• Other unsupported data sources: Oracle, Teradata and Relational SAP Hana
• Partially supported through XMLA / TOM endpoint programmability: SAP BW and SAP Hana

And excel not support direct query(Refer:https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources )

Smiilar case refer: 

https://community.powerbi.com/t5/Desktop/Power-BI-Dynamic-M-Query-Parameter-binding-not-shown/td-p/1...

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Rajagopal]