Bind to Parameter Not Showing

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/1457915

 

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