Problem when try to connect to Athena with Direct Query

QIAO — Mon, 18 Dec 2017 04:17:45 GMT

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;

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

Eric_Zhang — Wed, 20 Dec 2017 05:46:57 GMT

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

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

payal1 — Thu, 11 Jan 2018 20:32:03 GMT

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.

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

QIAO — Thu, 11 Jan 2018 20:41:40 GMT

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

I use cognito as security check.

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

payal1 — Fri, 19 Jan 2018 16:37:45 GMT

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

topic Re: Problem when try to connect to Athena with Direct Query in Developer

Problem when try to connect to Athena with Direct Query

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

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

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

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