Cannot Load Model

[Mer123]

I was wondering if anyone can help with the below problem.

I'm using Teradata presto ODBC driver to retrieve data from the source to power bi. The power bi connector I'm using is a custom connector, which I feed the parameters to the odbc.* functions. The power BI connector has two modes, import and DirectQuery, and there is also a native query (optional) that takes custom queries.

So, the challenge here is I couldn't load a model into Power BI using a custom connector in DirectQuery mode with a native query, but it worked as expected in all the rest three ways (without a native query for both modes and with a native query for import).

Assume the connection string has the DSN, host, port, and basic authentication.

The exact error is below

> Cannot Load Model:
>
> DirectQuery error: DirectQuery may not be used with this data source - please consider moving to a supported data source or upgrading the SQL Server data source to the latest available version.

[amitchandak]

@Mer123 , Native query is not always supported in Direct query.

Sometimes additional steps in power query will stop rolling the native query

Are you using the Standard ODBC driver or some third-party connector?

[Mer123]

Hi @amitchandak ,

Thanks for your reply.
I'm using a third-party ODBC (Teradata presto ODBC driver) and a custom power query connector.
Below is a sample of the code.

 // Use Odbc.Query with the provided NativeQuery

        QueryConnectionOptions = [

            CredentialConnectionString = EncryptedConnectionString

        ],

       result = if NativeQuery <> null then

                    // Use Odbc.Query with the provided NativeQuery

                    Odbc.Query(ConnectionString, NativeQuery, QueryConnectionOptions)

            else

                // Use Odbc.DataSource if native query is not provided

                    Odbc.DataSource(ConnectionString, ConnectionOptions)