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
bfrancis
Advocate I
Advocate I

on-premises data gateway (personal mode) SQL server basic login not working

I installed the latest On-premises data gateway (personal mode) today and a SQL server database I had been successfully connecting to with the previous version (Power BI gateway - personal) is no longer working.  Specifically, I cannot connect to the server's database using the "Basic" login mode.  This has worked flawlessly since the first versions of the personal DMG, so something has clearly been broken.  Also, I am able to connect to other data sources (databases) in the same server using Windows authentication mode.  So, the problem is with "Basic" login mode.

 

This is a serious issue for us since many reports being refreshed use this data source.  Anyone else experiencing this problem?  Any suggestions on how to resolve?

 

Thanks,

Bob

17 REPLIES 17

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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
Top Kudoed Authors