cannot refresh report automatically

Hi Biesse 

One other thing I would add is if you're using a gateway, log in to the gateway and see if you can connect to the SQL server from the gateway machine because sometimes there might be connectivity issues between the gateway and your SQL server as well. As mentioned above, try the Windows authentication or basic authentication when you are connecting from your gateway server.

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,

Hi all,

I'm waiting for some tests from our IT, I gave all the information you shared. 

I hope this can help, but I still don't have an answer for you. I'll let you know. 

Br 

Bianca 

Hi,

You may need to avoid using OAuth for SQL Server. Try using Windows Authentication or Basic Authentication via a gateway instead. Also make sure the on-premises data gateway is installed and running and confirm that the gateway is mapped to the correct data source and credentials.

In Power BI Service, Re-enter the SQL Server credentials in Data source credentials under Dataset Setting. 

Here is a post with similar error. 

Solved: DMTS_OAuthFailedToGetResourceIdError - Microsoft Fabric Community 

Hi Biesse ,
Just checking in to see if the issue is resolved.

The suggestions shared regarding verifying gateway connectivity and switching from OAuth to Windows or Basic authentication are aligned with the recommended approach for SQL Server connections.

Thanks to the community members for their guidance on this. If you are still facing issues after updating the credentials, please confirm whether your SQL Server is hosted on Azure, on-premises, or a VM so we can assist further.

Thank you.

Hi Biesse ,

May I know if your issue has been resolved, or if you still need any additional details? Please let us know if you need any further assistance.
 

Thank you.

Hi Biesse 

The error you’re encountering — DMTS_OAuthFailedToGetResourceIdError — typically indicates that Power BI is attempting to use OAuth authentication for a data source (in this case, SQL Server) that does not support it in your configuration. This often happens when the dataset’s credentials in the Power BI Service are incorrectly set or mismatched with the connection type defined in Power BI Desktop. To fix this, go to your Power BI Service → Settings → Datasets → Data source credentials, locate your dataset, and verify the authentication method. If your SQL Server is on-premises, ensure that it connects through an On-premises Data Gateway using Windows Authentication or Basic Authentication, not OAuth. Then, re-enter valid credentials with access to the SQL database and apply the changes. If your SQL Server is hosted in Azure (e.g., Azure SQL Database), then OAuth (via Azure AD authentication) can be used, but you’ll need to reauthorize the connection under your Power BI account. Also, ensure the gateway is online and properly mapped to the data source under Manage Gateways. Once credentials and gateway mapping are corrected, trigger a manual refresh — it should succeed, and subsequent scheduled refreshes will run without error.