Forum Discussion
ERROR [Simba][Driver Support] (1030) Failed to decrypt data: Key not valid for use in specific
Hi dy ,
Try the following solution from this link.
Enable the setting to encrypt passwords for all users of the machine.
- Open ODBC Data Source Administrator.
- Find the Athena Data Source in question.
- Click on Configure.
- Click on Authentication Options.
- Click on Password Options.
- Select the "All Users of this Machine" radio button and click OK.
- Re-test the connection.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Haha it's the same. i couldn't login with my previous account that's why create a new one.
One thing more wanna ask can we write query on power bi to get data from source if yes then how can we do this could you specify an example if i have to fetch from athena and want to write query in power bi to get data from athena
Hi dyn ,
Power BI has Power BI Desktop and Power BI Service. In Desktop, you can connect data sources and refresh data without a gateway. In Service, some specific data sources require you to configure gateways as bridges to connect data sources.
When you say athena, do you mean Amazon Athena? It needs the gateway to refresh in Power BI Service.
Power Query Amazon Athena connector - Power Query | Microsoft Docs
Using the Amazon Athena Power BI Connector - Amazon Athena
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.