Details: "Unable to find the requested .Net Framework Data Provider. It may not be installed."

 Hi there,

I am having the same problem (error message partly in german, but it reads the same), unfortunately the adivce regarding DbProviderFactories did not work.

I found references of machine.config in the following four places

#1 C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config

#2 C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

#3 C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config

#4 C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

I am new at this but #2 and #4 seem to be odd, going in the direction as to say "duplicate <DbProviderFactories> entry" as Romoreira suggests.

This what it looked like.

This is what i now looks like, uncommented that thing.

I restarted the PC, refreshed my pbix file, dragged some field on the report and still get the same error message.

I do have to day: I am using DirectQuery on the Oracle Database, the previews in PowerQuery load fine, its only when i drag and drop fields onto the report that I get this error. When I change from DirectQuery mode to Import mode, I do not get this error.

I also read somewhere that maybe installing "ODAC" (oracle data access components) from Oracle, but I am hesitant to do so since this is a work PC.

So does this directly relate to DirectQuery? Connecting to the Database in Power BI using ImportMode works fine.

Here's the source:

https://social.technet.microsoft.com/Forums/en-US/c06b9b93-fb55-4147-8d8b-0e613f9949fc/errors-in-the-backend-database-access-module-the-managed-provider-oracledataaccessclient-could?forum=sqlanalysisservices

http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html