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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Windows Authentication

My refresh stopped suddenly working. Dashboard is coming from one data source (connection to sql server) using windows authentication.

 

I'm using same windows credentials in my sql server as in data source settings below:

Capture.PNG

 

 

My connection in power bi desktop:

Capture.PNG

 Connection in power bi service seems to be set up just fine:

Capturee.PNG

 

I can refresh a dashboard locally in power bi desktop. However, refresh stopped working in power bi service and I get the following error:

Capture.PNG

 

Any suggestions? This data source (sql server) is the only source that stopped working and is using windows authentication. In the same cgateway cluster, I have connection to 5 other data sources, all databases and they all have been working fine.

1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hi @Anonymous ,

 

My first thought is as to whether or not you have updated the gateway.  I know that a lot of folks have had to recently update their gateway as they have gotten stale and the newer gateways have more capability and some more functionality.

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

2 REPLIES 2
collinq
Super User
Super User

Hi @Anonymous ,

 

My first thought is as to whether or not you have updated the gateway.  I know that a lot of folks have had to recently update their gateway as they have gotten stale and the newer gateways have more capability and some more functionality.

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

@collinq 

Yeah, I updated my standard gateway on VM and it works now. Thank you.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors