Odbc.Query on AAS through Visual Studio (An M partition uses a data function which results in access to a data source different from those defined in the model)

Question

Good afternoon,

Some of our developers are facing a very annoying issue when working with Visual Studio (2019)
They create a simple AAS cube where they define an ODBC Teradata connection , let's say "Odbc/authentication=td2;dsn=BIPDEV"

Once done , they do an import table and directly go on the powerquery editor to write their SQL query as follow

let
Source = Odbc.Query("Odbc/authentication=td2;dsn=BIPDEV", "select CURRENT_TIMESTAMP;"),
#"Added Custom" = Table.AddColumn(Source, "SOURCE", each "TERADATA STG")
in
#"Added Custom"

1. When they want to process, Our users receive the error message : (An M partition uses a data function which results in access to a data source different from those defined in the model). We are unable to understand this error message as we go directly as the datasource are the same as the one used in the M query
2. Is Is there a way , through Odbc.Query , to use directly the Data source name instead create a kind of new connection ?

Nota: We can confirm there is no issues in the query, the access right etc... and we've got the same error when using Sql.Database.

Answer 1

Forget my question , I found the root-cause

Our issue was double, somewhere in the xmla there was an "ldap" instead "td2" which generate this error.
In addition of that , the gateway linked to the AAS was not able to reach this teradata environment (port firewall closed)

Question can be closed - we will fix that quickly on our side :)

ps: sometimes dropping a question highlight the answer :)