Is direct query compatible with Amazon Athena?

[MinuMadhav_93]

Is direct query mode compatible with Amazon Athena from Power BI?

[djurecicK2 · Accepted solution]

Hi @MinuMadhav_93 ,

Yes, it is 

https://learn.microsoft.com/en-us/power-query/connectors/amazon-athena

Capabilities supported

Import
DirectQuery (Power BI semantic models)

[MinuMadhav_93]

HI @djurecicK2 ,

Thanks for confirming.

Initially, I was using Import mode, but due to the large volume of data, I switched to DirectQuery mode. However, I began encountering errors, and the "Apply changes" banner continued to appear even after clicking 'OK'.

The query starts with Value.NativeQuery. Could this be contributing to the issue? I would appreciate your insights on this matter.

Thanks & Regards

Minu