DMTS_DatasourceHasNoCredentialError Error in powerbiService.

Hi Anonymous 
Below are steps that resolve this issue:

1. Remove the Gateway:

   • In Power BI Service, navigate to your workspace and then to Data Source Settings.
   • If the gateway is selected and the option to remove it is greyed out, try to reconfigure the data source without selecting the gateway.
   • On the data source credentials page, click edit credentials and select none. This will bypass the need for a gateway.

2. Fixing the Credentials Issue:

   • Make sure you're using basic authentication or the appropriate method for PostgreSQL.
   • Enter the PostgreSQL credentials (username, password) along with SSL connection settings (if needed).
   • If the option to save credentials is disabled, it could be because Power BI is still trying to use the gateway. By switching to None (Cloud data source) in the credentials configuration, you should be able to save the credentials properly.

3. Check the Status:

   • After saving the credentials, ensure the connection status changes to Online.
   • If the status still shows as Offline, try refreshing the page, or check if there are any lingering configuration issues.

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