Custom Connector for PowerBi to enable limit clause support.

Hi Team,
I have designed a custom connector which supports native query, now I would like to add support for limit clause. I have done changes refering to this Parameters for the Odbc.DataSource function - Power Query | Microsoft Learn but I still dont see the Limit clause getting appended to the query I pass.
FYI: 

Added this piece of code in .pq

AstVisitor = [
            LimitClause = (skip,take) =>
                  if (skip > 0) then error "Skip/Offset not supported"
                   else
              [
                Text = Text.Format("LIMIT #{0}", {take}),
                Location = "AfterQuerySpecification"
              ]
        ],

Could you suggest what changes needs to be added to make it work as expected.