Incremental refresh failed with ODBC Athena

[Anonymous]

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

[Anonymous]

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]

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