Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
Employee

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.