Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
My connection in power bi desktop:
Connection in power bi service seems to be set up just fine:
I can refresh a dashboard locally in power bi desktop. However, refresh stopped working in power bi service and I get the following error:
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.
Solved! Go to Solution.
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!
Proud to be a Datanaut!
Private message me for consulting or training needs.
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!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Yeah, I updated my standard gateway on VM and it works now. Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.