Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

BriGoon

Error filtering blank values.

Submitted by on ‎05-17-2019 02:11 PM

I am connecting to Amazon Athena to pull some data. I want to filter out blank values but I get an error when attempting this.

 

"This step results in a query that is not supported in Direct Query mode."

 

I don't think I am doing anything here that should not work in direct query mode. I am testing out a custom connector from CDATA https://www.cdata.com/drivers/athena/powerbi/ I have reached out to their support team and they said that there is nothing on their end that would casue this issue. 

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-yulgu-msft
Employee
Employee
‎05-20-2019 12:43 AM

Hi @BriGoon ,

 

How did you filter out blank values, in data view mode or in Query Editor mode? Please provide more detailed information. Also, please check if you hit any limitation mentioned in this article.

 

Regards,

Yuliana Gu

Idea Statuses