Forum Discussion
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
- AnonymousNot 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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot 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