Can't Display the Visual

[Anonymous]

Hi have made live connection with SQL server.after loading data when i am try to craete any visual with dat its showing me following error as shown in snapshot.

Error Message:

The following exception occurred while the managed IDbConnection interface was being used: 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. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid);The parameter is incorrect.

How do i resolve it?

Regards,

Rahul M

[hawb]

Rahul, I'm having the same issue. I"m able to connect to database via Direct Query and load the data just fine.  But, once I try to create a visual I get the same error message as you.   Were you able to find a solution?

Mike

[v-haibl-msft]

@Anonymous

Can you get the data properly in Query Editor, and only get this error message while you create visuals with these data?

If you even cannot get the data properly in Query Editor, you need to check the connection between the machine where Power BI Desktop is installed and the SQL Server. Please see the troubleshooting steps in this document.

Best Regards,

Herbert

[Anonymous]

Hi Herbert,

I am getting this error only while loading visual.

please suggest some solutin for it.

Regards,

Rahul M