Using power BI gateway connection we are not able to connect to SQL Server database. We have one gateway created and few database connections to Analysis services. while we are trying to connect to database to access tables directly getting .below message. but we have .Net 4.5 framework already installed on the database server.
Error: "Unable to find the requested .Net Framework Data Provider. It may not be installed."
Solution that I found on the forum is: Deleting duplcate enties of "DbProviderFactories".
if this is the case where we find "machine config" files. Please provide detail steps.
Please follow errorssuck's suggestion here: https://community.powerbi.com/t5/Service/Error-Unable-to-find-the-requested-Net-Framework-Data-Provi...
Is the issue solved now?
In our case it got resolved updaing the domainame\username used for the datasource to case sensitive. domainname is changed to upper case(DOMAINNAME\username)