ODBC: ERROR [S1000] [Cache ODBC][State : S1000][Native Code 417]

[Aasir2]

Hello community,

Please help me with the below.

When I want to update a report in Power BI Desktop where one of its data sources is via ODBC and I get the error that I copy below. 
ODBC: ERROR [S1000] [Cache ODBC][State : S1000][Native Code 417] [C:\Program Files\WindowsApps\Microsoft.MicrosoftPowerBIDesktop_2.123.742.0_x64__8wekyb3d8bbwe\bin\Microsoft.Mashup.Container.NetFX45.exe] Access Denied

ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

Driver installed intersystems ODBC 64 bit

[Ritaf1983 · Accepted solution]

Hi, @Aasir2  there can be various troubles that cause this error 

please refer to the linked discussion :

https://community.fabric.microsoft.com/t5/Desktop/DataSource-Error-ODBC-ERROR-S1000-Cache-ODBC-State...

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[Aasir2 · Accepted solution]

Below worked for me,

I deleted the data sources in data files DSNs

Deteted DSNs from ODBC data sources

Uninstalled and reinstalled the Intersystems ODBC drivers.

Recreated the DSNs and this worked.

[Ritaf1983 · Accepted solution]

Hi, @Aasir2  there can be various troubles that cause this error 

please refer to the linked discussion :

https://community.fabric.microsoft.com/t5/Desktop/DataSource-Error-ODBC-ERROR-S1000-Cache-ODBC-State...

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[Aasir2]

Thank you, I already went through this discussion but it didn't help.