'having trouble accessing MySql database by power bi use unable to connect we encountered a error?
While trying to access the database from POWER BI to MYSQL getting a error as
UNABLE TO CONNECT
we encountered a error while trying toconnect 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. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)'
Solution 1:[1]
In the data source setting, can you remove the existing SQL server source connection and try again? You can set permission when creating the data source.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | abaci |