Unable to connect to Oracle in Visual Studio 2022 Analysis service project
Unable to connect to Oracle in Visual Studio 2022 Analysis service project and getting the below error
Error
Details: "Failed to find or load the registered .Net Framework Data Provider.. This is a configuration issue with the file 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config'."
I followed instructions here - https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database#installing-the-oracle-client and installed oracle and can connect and work with Powerbi ( latest december release) but in Visual Studio2022 I m getting the error
Below are entries in the Machine config
<DbProviderFactories>
<add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
<add name="ODP.NET, Unmanaged Driver" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET, Unmanaged Driver" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>