Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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?
Solved! Go to Solution.
It worked. We need to change and edit the permissions on data sources in power bi. now its working
It worked. We need to change and edit the permissions on data sources in power bi. now its working
Are you saying that you want to use windows authentication? Then change the authentication method to Windows. (dropdown)
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
Anyone care to help?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.