cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
QIAO
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
payal1
Frequent Visitor

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

payal1
Frequent Visitor

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.

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

I use cognito as security check.

Eric_Zhang
Microsoft
Microsoft

@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.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors