Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Athena Incremental Refresh

Hi All   I have been successfully using Power BI’s incremental refresh daily with a MySQL data source. However, I can't get this configured with AWS Athena, because seemingly the latter interpret...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

Based on my test,I cannot reproduce your issue here. How about deleting other steps to check again?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-frfei-msft , thanks for the response.

     

    Here's the entire M query, which I have reduced slightly to the most relevant elements.

     

    let
    Source = Odbc.DataSource("dsn=athena", [HierarchicalNavigation=true]),
    AwsDataCatalog_Database = Source{[Name="AwsDataCatalog",Kind="Database"]}[Data],
    test_Schema = AwsDataCatalog_Database{[Name="test",Kind="Schema"]}[Data],
    cpbd_test_Table = test_Schema{[Name="cpbd_test",Kind="Table"]}[Data],
    #"Filtered Rows" = Table.SelectRows(#"cpbd_test_Table", each [adv_date] >= RangeStart and [adv_date] < RangeEnd)
    in
    #"Filtered Rows"

    As you can see, all I am doing is selecting the entire table and attempting to filter on the datetime column.  I still have the same error as above.