Forum Discussion
cannot refresh report automatically
Hi, I created a report linked to sql server. I cannot refresh it automatically because of incorrect credentials. This is the error I had: Failure details: The last refresh attempt failed...
Hi. Is this a SQL Server in azure or is it onpremise or inside a VM. If this is a cloud instance go to Data Source settings for the Semantic Model and edit the credentials for the source. If this is local instance you should use a Power Bi Gateway. You can read more info in here: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
I hope that helps,