Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
We're using powerbi and report server at our organisation. We've got PowerBI October 2017 installed, but it happens on the most normal recent version as well.
When trying to connect to a MySQL database this error appears:
Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Access is denied.'"
The enviroment is installed on Server 2016, it did work flawlessly in the beginning. No clue what happened in the meantime. Havent changed anything on the server, might be an update of windows?
I've tried the following but all attempts failed;
Nothing helps. It happens on all MySQL Server connections.
Please help,
Have you tried something like:
"C:\Program\Microsoft SDKs\Windows\v6.0A\bin\gacutil.exe" /i Microsoft.NET/Framework/v2.0.50727/System.EnterpriseServices.dll"
?
@Greg_Deckler Our server does not contain these directory's, what are you exactly trying to do with this?
By the way i forgot to say that the connection does work on other machines. But this is our PowerBI development enviroment so it must work on this server.
https://docs.microsoft.com/en-us/dotnet/framework/tools/gacutil-exe-gac-tool
@Greg_Deckler, unfortunately it seems that my server does not contain the folder Microsoft SDKs
I think that the intent here is to the find the path to the DLL that you want and enter that path and DLL into the gacutil as a parameter.
Open a command prompt and then type:
C:\WINDOWS\system32>cd \ C:\>dir System.EnterpriseServices.dll /s Volume in drive C is Windows Volume Serial Number is B875-7992 Directory of C:\Windows\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a 13-07-2016 14:33 258.048 System.EnterpriseServices.dll 1 File(s) 258.048 bytes Directory of C:\Windows\assembly\GAC_64\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a 14-07-2016 14:18 245.760 System.EnterpriseServices.dll 1 File(s) 245.760 bytes Directory of C:\Windows\Microsoft.NET\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a 25-09-2018 20:50 241.896 System.EnterpriseServices.dll 1 File(s) 241.896 bytes Directory of C:\Windows\Microsoft.NET\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a 25-09-2018 20:50 241.376 System.EnterpriseServices.dll 1 File(s) 241.376 bytes Directory of C:\Windows\Microsoft.NET\Framework\v2.0.50727 13-07-2016 14:33 258.048 System.EnterpriseServices.dll 1 File(s) 258.048 bytes Directory of C:\Windows\Microsoft.NET\Framework\v4.0.30319 25-09-2018 20:50 241.896 System.EnterpriseServices.dll 1 File(s) 241.896 bytes Directory of C:\Windows\Microsoft.NET\Framework64\v2.0.50727 14-07-2016 14:18 245.760 System.EnterpriseServices.dll 1 File(s) 245.760 bytes Directory of C:\Windows\Microsoft.NET\Framework64\v4.0.30319 25-09-2018 20:50 241.376 System.EnterpriseServices.dll 1 File(s) 241.376 bytes Directory of C:\Windows\WinSxS\amd64_system.enterpriseservices_b03f5f7f11d50a3a_10.0.14393.0_none_44fa693639cad351 14-07-2016 14:18 245.760 System.EnterpriseServices.dll 1 File(s) 245.760 bytes Directory of C:\Windows\WinSxS\amd64_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14305.0_none_3df951ed8dd9fc53 16-07-2016 15:19 241.384 System.EnterpriseServices.dll 1 File(s) 241.384 bytes Directory of C:\Windows\WinSxS\amd64_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14320.17035_none_f5ce3dd8bdd91d80 25-09-2018 20:50 241.376 System.EnterpriseServices.dll 1 File(s) 241.376 bytes Directory of C:\Windows\WinSxS\x86_system.enterpriseservices_b03f5f7f11d50a3a_10.0.14393.0_none_8ca7a00d4e46fc57 13-07-2016 14:33 258.048 System.EnterpriseServices.dll 1 File(s) 258.048 bytes Directory of C:\Windows\WinSxS\x86_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14305.0_none_85a688c4a2562559 16-07-2016 15:20 241.896 System.EnterpriseServices.dll 1 File(s) 241.896 bytes Directory of C:\Windows\WinSxS\x86_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14320.17035_none_3d7b74afd2554686 25-09-2018 20:50 241.896 System.EnterpriseServices.dll 1 File(s) 241.896 bytes Total Files Listed: 14 File(s) 3.444.520 bytes 0 Dir(s) 88.227.123.200 bytes free
This is the output
Tried finding gacutil.exe no success. Might need to install it.
Hmm, the following lines show that it is in the GAC
Directory of C:\Windows\Microsoft.NET\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a 25-09-2018 20:50 241.896 System.EnterpriseServices.dll 1 File(s) 241.896 bytes
Directory of C:\Windows\Microsoft.NET\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a 25-09-2018 20:50 241.376 System.EnterpriseServices.dll 1 File(s) 241.376 bytes
So, the interesting part to me is the "Access is denied". That seems very odd.
If you have a Pro account, I would report this as an issue.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
I don't have a pro account at this moment. Might look into this later on.
Is there a way to fix this easily? We really need this to be working again. I find it odd that it still doens't work after reinstalling powerbi, the mysql connector, and upgrading .net
I probaly found the cause. A windows update:
https://support.microsoft.com/en-us/help/4345418/windows-10-update-kb4345418
The following update should fix it:
http://www.catalog.update.microsoft.com/Search.aspx?q=KB4346877
Im trying it out right now
Any update on this? We need this data for board reports and with the connection no longer working we will have to very quickly build it manually.
I'd wish to have the answer. We still have the same issue.
I had high hopes, but NOPE!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |