Getting connections error when updating Power BI table from AWS source

Hello,

I understand that you are getting error : "ODBC: ERROR [08S01] [Simba][DriverIAMSupport] (8600) Connection Error: SAML assertion not found" from PowerBI console.

Seems this error could not be an issue either with the SAML or the ODBC driver itself - but i am not 100% sure at this stage with the available information. Generally we do get connection error with SAML assertion with miss-configurational setup or it is getting SAML messages it is not expecting. Further you can check these also:

1. Kindly check if there is any incorrect DSN connection configuration parameters in ODBC Data Source Administrator.

2. Sometimes the ODBC driver incorrectly parses the connection url and cut the url if there is an = sign. To make sure this is not the cause of the issue, can you “escape the url using the mechanism described in the specification in [1]”. Kindly escape the equal signs by replacing = with {=} and check if you are able to establish the connection.

You can follow this detailed steps to Access Athena from PowerBI. https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc-and-power-bi.html