ERROR [Simba][Driver Support] (1030) Failed to decrypt data: Key not valid for use in specific

[dy]

Hi, It's been a week stuck on it. having error "Failed to decrypt data: Key not valid for use in specified state". 

let me brief you about my scenario,  I'm using enterprise gateway. all data sources is working fine, in which i used data import method. but when i use Direct Query method it's giving me this error "Failed to decrypt data: Key not valid for use in specified state". Pls help me. 

Please find below error screenshot

[Anonymous · Accepted solution]

Hi @dy ,

Try the following solution from this link.

Enable the setting to encrypt passwords for all users of the machine.

1. Open ODBC Data Source Administrator.
2. Find the Athena Data Source in question.
3. Click on Configure.
4. Click on Authentication Options.
5. Click on Password Options.
6. Select the "All Users of this Machine" radio button and click OK.
7. 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.

[jarmer12]

Hi I know this is an old thread, but I am getting the same error when trying to connect with BigQuery. Someone else with the same service credentials can access the data fine, but I get this error when trying to connect. 

[Anonymous]

Thank you, Stephen Tao!

[Anonymous]

Hi @Anonymous , can I ask what selecting "All Users of this machine" does?

[dyn]

@Anonymous Realy greatful it works now that error has been fixed by performed suggested config however now i'm getting this error. pls have a look into this. Thanks again for your reply

[Anonymous]

Hi @dyn ,

Are you @dy ? Or is it just the same name?😂

The error message shows that you don't seem to have a gateway configured for your data source.

Please refer to 

Add or remove a gateway data source - Power BI | Microsoft Docs

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.

[dyn]

@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 

[Anonymous]

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.

[dy]