Forum Discussion
Connect to Service Manager DWDataMart
Hi Adriang,
Based on your description, you are connecting to remote SQL Server from Power BI Desktop. Firstly , check that if you can successfully connect to the remote SQL instance from other application(such as Excel) on your Laptop.
Sexondly, if you are able to connect to SQL from Excel on your Laptop, launch Power BI desktop with admin privileges, delete any SQL Server data source from "options" -> "Data source settings" in Power BI Desktop, then check if you can connect to the remote SQL. If the issue persists, please uninstall Power BI Desktop and reinstall it, then connect to SQL Server.
Thanks,
Lydia Zhang
Hi Adrian,
Do you use Windows login or SQL login to connect to SQL Server? Could you please post the screenshot. Also use SSMS to test the connection and check the result.
Thanks,
Lydia Zhang
Hi Lydia
I use a windows login which is an Admin account for our environment. I can log on perfectly to SQL using that account.
Below is the error i get. Also note i have PowerBi local on my Laptop and i am connecting to SQL that is not local and is on a server in our domain.
Regards
Adrian Govender
Hi Adriang,
Based on your description, you are connecting to remote SQL Server from Power BI Desktop. Firstly , check that if you can successfully connect to the remote SQL instance from other application(such as Excel) on your Laptop.
Sexondly, if you are able to connect to SQL from Excel on your Laptop, launch Power BI desktop with admin privileges, delete any SQL Server data source from "options" -> "Data source settings" in Power BI Desktop, then check if you can connect to the remote SQL. If the issue persists, please uninstall Power BI Desktop and reinstall it, then connect to SQL Server.
Thanks,
Lydia Zhang