Forum Discussion

c_d_m's avatar
c_d_m
Regular Visitor
2 years ago
Solved

Amazon Athena connector with Direct Query not working when using value.nativequery

Hi, i have a power bi model using direct query with an amazon athena connector when i use it as desktop the model works fine but when i publish it to power bi service i get the error: Unable to conn...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi c_d_m 

     

    According to the following official documentation, Amazon Athena is probably not supported by Value.NativeQuery function as it is not listed in Supported data connectors. 

    Query folding on native queries - Power Query | Microsoft Learn

     

    With Import mode, it will load data into Power BI. When some operations are not supported by query folding, it loads data into Power BI then uses Power Query engine to deal with it. So you see it works fine with Import mode. However with DirectQuery, Power Query engine won't deal with it so it may fail. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi c_d_m 

 

According to the following official documentation, Amazon Athena is probably not supported by Value.NativeQuery function as it is not listed in Supported data connectors. 

Query folding on native queries - Power Query | Microsoft Learn

 

With Import mode, it will load data into Power BI. When some operations are not supported by query folding, it loads data into Power BI then uses Power Query engine to deal with it. So you see it works fine with Import mode. However with DirectQuery, Power Query engine won't deal with it so it may fail. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!