Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Incremental refresh failed with ODBC Athena

Hi everyone,

I used Logic Apps to start gateway to Athena and run incremental refresh dashboard in Power Bi Service. In the last week, it was refreshed successfully, but this week I got the error: 

Data source error:{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 130, HTTP Response Code: 400, Exception Name: InvalidRequestException, Error Message: Prepared Statement stmthetRuB4rhkAAAAAAAABMQA000 already exists in WorkGroup primary "}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=Simba Athena"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}

 


It just happen the issue when run Logic Apps, it will refresh successfully if I refresh manually in Power Bi Service
Does anyone have any experience with this issue, please help me.

Thank you

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Please have a try.

    • Check if the credentials used for the scheduled refresh are correct and up-to-date.
    • Check if there are any errors or warnings in the refresh history of the dataset.
    • Try refreshing the dataset manually using the same credentials as the scheduled refresh to see if it works.
    • AWS Athena Dataset requires a properly configured gateway in order to refresh, You can try installing and configuring the JDBC/ODBC driver on the Power BI Data Gateway Server.

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous 
      I used Logic Apps to scheduled refresh (it works normally with other reports)
      If I refreshed the dataset manually in local or powerBi service, it would refresh successfully
      And it doesn't always refresh failed