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.

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
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Kudoed Authors