I am trying to connect sql server of eramba with Power BI followed the steps according to eramba documentation but its showing some error.
Errors are :
we could not authenticate with provided credential.But i provided correct credential.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
Assuming you usedthe docker method for install (basically, if you’ve installed in the past couple years), the database is probably only accessible to the internal docker network and not exposed. You’ll probably need to look at the docker compose yaml file and modify it to expose the port.
The database is probably only accessible to the internal docker network and not exposed. You’ll probably need to look at the docker compose yaml file and modify it to expose the port.
For exposing the docker MySQL in external network:
we were trying to port mapping in docker compose file but at first it was not taking that port because in my ubuntu OS a another MySQL service running on the same port.
Then we uninstalled that MySQL from my ubuntu Linux server.
Added port in compose file for MySQL configuration. Now it’s working properly.
we are able to fetch data from Eramba to Power BI.