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,
I am trying to use Alternate credentials of Window to connect SQL Database, encountering error of couldn't authenticate with credentials. I am able to connct same instance from SSMS without any issue.
I tried with live and import onnection. no luck!.
Anything special needs to take care? Please share your thought.
I fixed this running PowerBI as an Administrator.
Right click on Power BI icon , (right click on the icon again if it was in your task bar) and select "Run as administrator"
Hi Miruthan,
What about using default windows authentication or database authentication? And please check if your sql server instance allows remote connection.
Regards,
Jimmy Tao
@v-yuta-msftI am able to RDP the SQL server instance. Database authentication and Default window authetication dont have access on Database. Only alternate credentials.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |