Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
SriGaG
Frequent Visitor

Power BI Gateway creation - User name and password

Dear Experts.

 

I am trying to update my power bi file creating gateway using sql. But i am not having a username and password for sql server as stated in the below pic. I have downloaded the standard gateway fro microsoft and created a gateway. But it dosent let me to create the connection without inputting the username and password here. 

 

PS - I am using a personal sql profile and use windows authentication in sql. Is there any way to sort this out and go ahead without putting a password and username for the below?Capture.PNG

1 ACCEPTED SOLUTION
SriGaG
Frequent Visitor

It worked. We need to change and edit the permissions on data sources in power bi. now its working

View solution in original post

3 REPLIES 3
SriGaG
Frequent Visitor

It worked. We need to change and edit the permissions on data sources in power bi. now its working

sevenhills
Super User
Super User

Are you saying that you want to use windows authentication? Then change the authentication method to Windows. (dropdown)

sevenhills_0-1629484581130.png

 

Choose Basic for SQL authentication and enter username and password.

 

It is not clear what type of authentication you want to use from your message...

 

Check this article for more details,

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

SriGaG
Frequent Visitor

Anyone care to help?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors