cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Matt_H_Clam
Regular Visitor

Connecting to SQL Server issue

I have started a new role and have been given some credentials for an SQL server (hosted i think)

 

I can ping the server and i can rdp onto it using the server name and windows authentication 

 

What I cant do is to connect with Power Query, any ideas?

1 ACCEPTED SOLUTION

All, thanks for your contributions.

 

To close this thread down I think the DBA had given me incorrect credentials/authentication method.

 

I looked myself in the users list in SQL server (when i rdp'd onto it) and found a read-only account used by the finance team for some of their sprerdsheets so I used that account and used database authentication and bingo, i'm in.

 

 

 

Cheers

 

Matt

View solution in original post

5 REPLIES 5
Fowmy
Super User
Super User

@Matt_H_Clam 

What sort of error mesage are you getting while trying to connect ?
Select the right  type of authentication : Organizational, Windows  . . . 


 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

All, thanks for your contributions.

 

To close this thread down I think the DBA had given me incorrect credentials/authentication method.

 

I looked myself in the users list in SQL server (when i rdp'd onto it) and found a read-only account used by the finance team for some of their sprerdsheets so I used that account and used database authentication and bingo, i'm in.

 

 

 

Cheers

 

Matt

Hi, Im using Windows authentication and get the message "We couldnt authenticate with the credentials provided"

 

I can rdp onto the server and open management studio, I can see the user in the list in there

Hi @Matt_H_Clam ,

For windows auth, try using <domain_name>\<username> as the username if you're not already doing so.

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

@Matt_H_Clam 

Under Data Source Setting in Power BI, clear the connection and credentials and connect to SQL and renter the servername and credentials and try. 

If you have DBA, get it checked

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors