cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Odbc.Query does not work with Direct Query option in Custom Power BI connector

Hi, 

I am trying to create my own custom connector for Presto and i was trying to pass SQL query using Odbc.Query function with Direct Query enabled but I am getting below error when i am trying to load data for reports generation.

"We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct, and that you have permission to access them. 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."

 

Is this feature not supported for Custom connector or is it a bug on power bi side as i have tried various ways to fix it, like updating my power bi desktop to latest, run power bi desktop in admin mode, using latest presto server version but nothing works. 

Below is my code snippet. SQl query works fine for import options but it is not working for Direct Qery option.

Connect = 
            if (SQL = null) then 
                Odbc.DataSource(ConnectionString, [
                HierarchicalNavigation = true,
                HideNativeQuery = false,
                TolerateConcatOverflow = true,
                SqlCompatibleWindowsAuth = false,
                ClientConnectionPooling= true,
                SoftNumbers = true,
                SqlCapabilities = [
                    PrepareStatements = true,
                    SupportsTop = true,
                    Sql92Conformance = 8,
                    SupportsNumericLiterals = true,
                    SupportsStringLiterals = true,
                    SupportsOdbcDateLiterals = true,
                    SupportsOdbcTimeLiterals = true,
                    SupportsOdbcTimestampLiterals = true
                    ]
                ])
            else
                Odbc.Query(
                ConnectionString, 
                SQL)
    in
        Connect;

 Please reply. Thanks in advance.

3 REPLIES 3
Highlighted
Super User IV
Super User IV

@pupreti , I think direct query source are limited to given in the list

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted

Hi @amitchandak , i think that list is for the the connectors that comes with power bi and not for the case of local custome connector.

Highlighted
Community Support
Community Support

Hi @pupreti ,

 

Please refer to the article.

DirectQuery DataDirect ODBC drivers in Power BI 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors