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 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
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
@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
Hi Herbert,
I am getting this error only while loading visual.
please suggest some solutin for it.
Regards,
Rahul M
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |