Regardin to Power Bi Error

[SachinBhalerao]

{"error":{"code":"DMTS_DatasourceHasNoCredentialError","pbi.error":{"code":"DTMS_DatasourceHasNoCredentialError","details":[{"code:"Server","detail ":{"type":1,"value ":"172.16.114.200"}},{"code":"Database","detail":{"type":1,"value":"fin_mis"}},{"code":"ConnectionType","detail:{"type":0,"value":"SQL"}}],"exceptionCulprit":1}}}.

Hi I got above error but i a not able to detect this error i need your help to resolve this error please help me.

[anmolmalviya05 · Accepted solution]

Hi @SachinBhalerao, Hope you are doing good!

The error message you're seeing indicates that Power BI is unable to connect to your SQL Server data source because the credentials are missing or not set up properly.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[SachinBhalerao]

Yes Amol but is their any need of gateway

[anmolmalviya05]

Steps to Resolve the Error:

1. Go to Power BI Service:

   • Open Power BI Service (https://app.powerbi.com/).
   • Navigate to the workspace where your report or dataset is located.

2. Update Data Source Credentials:

   • Find your dataset under the "Datasets" section.
   • Click on the ellipsis (...) next to the dataset and select "Settings."
   • Under "Settings," scroll down to "Data source credentials."
   • Click on "Edit credentials."
   • Choose the appropriate authentication method (e.g., "Basic" for username and password, or "OAuth2" if your server uses Azure AD).
   • Enter your credentials (username and password) for the SQL Server.
   • Click "Sign in" or "Connect" to save the credentials.

3. Test the Connection:

   • After updating the credentials, test the connection to ensure it is successful.
   • Go back to the workspace and refresh the dataset manually to see if the error persists.

4. Check Gateway Configuration (if applicable):

   • If your data source is on-premises, ensure that an on-premises data gateway is installed and configured properly.
   • Go to "Manage gateways" in the Power BI Service.
   • Ensure that the gateway is running and the data source is configured correctly under the gateway settings.

5. Re-upload the Report (if necessary):

   • If the issue persists, consider re-uploading the report to the Power BI Service and configuring the credentials again.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!