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

Question

I am trying to connect to MS SQL Server. Getting this error:Details: "Unable to find the requested .Net Framework Data Provider. &nbsp;It may not be installed."&nbsp;Googled. No luck.

romoreira · Answer

I found a solution: in my case the machine config has a duplicated entry "DbProviderFactories". As soon as I deleted one of them and restarted PowerBi, it&nbsp;started to work.&nbsp;

chefe · Answer

&nbsp;Hi there,&nbsp;I am having the same problem (error message partly in german, but it reads the same), unfortunately the adivce regarding DbProviderFactories did not work.&nbsp;I found references of machine.config in the following four places&nbsp;#1 C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config#2&nbsp;C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config#3&nbsp;C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config#4&nbsp;C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config&nbsp;I am new at this but #2 and #4 seem to be odd, going in the direction as to say "duplicate &lt;DbProviderFactories&gt; entry" as Romoreira suggests.&nbsp;This what it looked like.&nbsp;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&nbsp;onto the report that I get this error. When I change from DirectQuery mode to Import mode, I do&nbsp;not get this error.&nbsp;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.&nbsp;So does this directly relate to DirectQuery? Connecting to the Database in Power BI using ImportMode works fine.&nbsp;Here's the source:&nbsp;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&nbsp;http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html&nbsp;

chrisrenlund · Answer

This is what solved it for us:In the case with direct query towards an Oracle database this is what solved above error message for us:Install Oracle Client 12.1 (64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64) as an additional Oracle home on your gateway server (we were running 12.2)Restart you On-premises data gateway (it did not work if you didn't restart the gateway)Seems as Oracle 12.2 for some reason doesn't work with direct query.

leonardmurphy · Answer

Where are you trying to connect from? The Power BI desktop app? Do you mind sharing the exact steps you're taking?

romoreira · Answer

I'm experience exactly the same problem. I've just installed Power BI Desktop.

Forum Discussion

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

9 Replies

Related content

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

Always receiving "Unable to execute the SQL request" after 4min

Feature Request: Matrix Visual

"Install this app automatically" Checkbox greyed out

Unable to Publish Pipeline : {"code":UnknownError","pbi.error":{"code":{UnknownError"}}