Forum Discussion
Cannot Load Model
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.