I need to connect to an external Datasource through ODBC connector in PowerBI.
The ODBC connector, requires multiple parameters, from
- region
- ak/sk
- schema
I don't think is necessary to configure ONE ODBC connection per each desired connection (e.g. I want to connect to different schemas).
The connection string is in the form of:
jdbc:dli://dli.ap-southeast-2.myhuaweicloud.com/SECRET_PROJECT_ID?databasename=DESIRED_DATABASE;queuename=default;authenticationmode=aksk;servicename=dli;regionname=ap-southeast-2;accesskey=MY_AK;secretkey=MY_SECRET_SK;
I would like to avoid configuring some of the parameters on the ODBC admin, and pass it in the connection string parameters on PowerBI:
Please, experts on ODBC and PowerBI, help me :).
Additional information:
NOTE: ODBC works, works on DBeaver