Forum Discussion
Power BI to Dataverse Connection
Hi Anonymous
Thanks for reaching out to us.
>> Error occured while establishing a connection to SQL server. The server was not found or was not accessible.
For this error, please refer to this article, Fixed – Error – “Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server” – while trying to use Dataverse connector in Power BI – Nishant Rana's Weblog
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you for you repsonse v-xiaotang.
I have tried the solution within the link you provided, however I am still unable to load the data. Because connection to the enviroment have already been established, it doesn't even allow me to copy and paste the enviroment URL. I have also tried disconnectiong the connection estbalished, and tried connecting it again. It automatically directs me to sign in to my organization account, and which later loads all the folders to the enviroments. When I click on the enviroments, it doesn't load the tables.It gives me the following error.
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"
Am I missing some kind of steps. I also have the TDS endpoint on.
Thank you again!