[Python] Unrecognized configuration parameter "sap_ashost"

I'm connecting to SAP BW Application Server cube from Fabric Notebook (using Python) using duckdb+erpl . I use connection parameters as per documentation:

conn = duckdb.connect(config={"allow_unsigned_extensions": "true"})
conn.sql("SET custom_extension_repository = 'http://get.erpl.io';")
conn.install_extension("erpl")
conn.load_extension("erpl")

conn.sql("""
SET sap_ashost = 'sapmsphb.unix.xyz.net';
SET sap_sysnr = '99';
SET sap_user = 'user_name';
SET sap_password = 'some_pass';
SET sap_client = '019';
SET sap_lang = 'EN';
""")


ERPL extension is loaded successfully. However, I get error message:

CatalogException: Catalog Error: unrecognized configuration parameter "sap_ashost"
​

For testing purposes I connected to SAP BW thru Fabric Dataflow connector and here are the parameters generated automatically in Power M which I use as values in parameters above:

Source = SapBusinessWarehouse.Cubes("sapmsphb.unix.xyz.net", "99", "019", [LanguageCode = "EN", Implementation = "2.0"])


Why parameter is not recognized if its name is the same as in the documentation? What's wrong with parameters? I tried capital letters but in vain. I follow this documentation: https://erpl.io/docs/integration/connecting_python_with_sap.html and my code is same as in the docs.

Continue reading...