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

The Fabric Community site will be in read-only mode on Monday, Feb 24 from 12:01 AM to 8 AM PST for scheduled upgrades.

Reply
idanco
Advocate II
Advocate II

Power BI personal gateway error

I have an Excel Powerpivot model uploaded to Power BI

* Personal Gateway is installed and running

* i have one Power Query source - Sql Server , i use server login

* when i type the login details on the "Manage data sources" section - i get "Login Failed" 

Even though this is the correct login.

 

I had this issue in several cases, Did someone manage to refresh a data model using the personal gateway ? 

 

Any idea how to resolve this ? 

1 REPLY 1
Greg_Deckler
Super User
Super User

I am seeing the same thing on my gateway and, worse, my SQL Server is local. I tried both Windows and Basic authentication and both failed even though I can sign on to SQL Server Management Studio with both of those credentials successfully.

 

I sent a frown.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.