Authentification error on Gateway

Hi ict ,

This issue is caused by the credentials of your data source.

It seems that you are using the username and password of your gateway?

When setting the datasource: select an Authentication Method to use when connecting to the data source. For SQL Server, choose Windows or Basic (SQL Authentication). Enter the credentials for your data source.

Note: If the selected authentication method is OAuth:

• Any query that runs longer than the OAuth token expiration policy may fail.
• Cross-tenant AAD accounts are not supported If the selected authentication method is Windows:
• Make sure that account has access on the machine. If not sure, make sure to add NT-AUTHORITY\Authenticated Users (S-1-5-11) to the local machine “Users” group.

For more details, please refer to:

Add or remove a gateway data source - Power BI | Microsoft Learn

Manage your data source - SQL - Power BI | Microsoft Learn

Troubleshoot gateways - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.