Forum Discussion
An error while connecting to SQL base
How you are trying to connect to SQL Server?
Is it working in Power BI Desktop ?
Is it giving error in Power BI Service or PBI Report Server?
Does your user have given permission to SQL DB ?
FarhanAhmed We use the latest version of PBI desktop. Trying to Get Data -> SQL Server.
There's no doubt the user has all needed permissions to SQL DB because when I run PBI desktop as Administartor and we authetificate using "alternative credentials" and enter user's credentials, everything works properly. But when user runs PBI desktop in usual way he gets this error just after he clicks Get Data -> SQL Server.
This is very known issue when using Alternate Credentials. Microsoft itself recommend it to open it using "Run As Administrator." Unfortunately whenever you will try to add new table in your model, you need to do it same.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-error-launching-desktop