cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Problem when try to connect to Athena with Direct Query

I don't know Direct Query very much. I have tried successfully to use ODBC Driver to connect to Athena using import mode. But I got a lot of problems when it comes to use Direct Query. And I have traced the ODBC log, not ERROR log found.

Here is the stack:

Feedback Type:
Frown (Error)

Timestamp:
2017-12-18T04:08:30.5680135Z

Local Time:
2017-12-18T17:08:30.5680135+13:00

Session ID:
8344369f-a76b-4b25-acbd-24e3daf77ac4

Release:
December 2017

Product Version:
2.53.4954.481 (PBIDesktop) (x64)

Error Message:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..

OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 en-GB)

CLR Version:
4.7 or later [Release Number = 461308]

Peak Virtual Memory:
33.8 GB

Private Memory:
281 MB

Peak Working Set:
420 MB

IE Version:
11.125.16299.0

User ID:
03567265-88fc-4e3e-9713-7c0d41fb9c47

Workbook Package Info:
1* - en-NZ, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\ping.qiaop\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1409790640.zip

Performance Trace Logs:
C:\Users\ping.qiaop\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
CustomConnectors

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
PBI_reportBookmarks
PBI_AdobeAnalytics
PBI_qnaExplore

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Activity ID:
null

Time:
Mon Dec 18 2017 17:08:25 GMT+1300 (New Zealand Summer Time)

Error Code:
QueryUserError

OData Error Message:
Failed to execute the DAX query.

DPI Scale:
200%

Supported Services:
Power BI

Formulas:


section Section1;

shared events = let
Source = ThriveConnector.Database(null),
thrive_development_Database = Source{[Name="thrive_development",Kind="Database"]}[Data],
events_Table = thrive_development_Database{[Name="events",Kind="Table"]}[Data]
in
events_Table;

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: Problem when try to connect to Athena with Direct Query

@QIAO

I don't quite get your problem. As known, ODBC is not in the supported list, see Data sources supported by DirectQuery in Power BI.

Highlighted
Regular Visitor

Re: Problem when try to connect to Athena with Direct Query

can u pls suggest how you set up ODBC connection to Athena. i have installed the drivers but facing difficulty in connecting. what did you put in authentication options.

Highlighted
Helper II
Helper II

Re: Problem when try to connect to Athena with Direct Query

I wrote an ODBC driver myself but not the one you can see on Aws Athena site.

I use cognito as security check.

Highlighted
Regular Visitor

Re: Problem when try to connect to Athena with Direct Query

we are able to connect to Athena thru ODBC drivers. but any time if apply any query level filters, it gives below error. Please suggest

athena error.PNG

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.