Failed to test the connection to your data source. Please retry your credentials

[Barattolo_67]

I have connected Power BI desktop to a SharePoint list using the below connection settings:

I have been able to create the query and the visuals in Power BI desktop. However, when I publish the report to the Power BI Service I get an error:

If I then go to the settings of the semantic model, I can see a further error:

If I try to edit the credentials of the problematic data source, the only authentication methods available are: Anonymous, OAuth2, and Service Principal. Neither of these serves my purpose as I would need to be able to use my organizational account.

Any clues on what might be going on? Any help will be greatly appreciated.

[Barattolo_67]

Thanks, nut the responses have not addressed my issue.

[v-aatheeque · Accepted solution]

Hi @Barattolo_67 ,

Apologies for the inconvenience. we recommend raising a  support ticket How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn for further assistance.

Regards,
aatheeque.

[v-aatheeque]

Hey @Barattolo_67 ,

Since we haven’t heard back from you in some time, we’ll proceed to close this thread. Should you need further assistance in the future, please don’t hesitate to post a new question in the Fabric Community — we’re always here to help.

Thank you for being an active part of the community!

[GilbertQ]

Hi @Barattolo_67 

Using the oauth 2 will use your organizational account to complete the authentication. So if you can try that,

[Barattolo_67]

Thanks, but I have tried that, and it does not work.

[v-aatheeque]

Hi @Barattolo_67 ,

Thanks for reaching out to the Microsoft Fabric Community forum.

When you encounter a "failed to test the connection to your data source" error, it typically meansthere was an issue with the credentials you provided or with the data source itself. Here are some steps you can take to troubleshoot and resolve this error: :

• Double-check the username and password you entered for the data source. Ensure there are no typos or incorrect characters.
• Ensure that the credentials you are using have the necessary permissions to access the data source. Sometimes, limited permissions can prevent a successful connection.
• In some cases, cached credentials can cause issues. Clear any cached credentials and try re-entering them.
• If you are using an On-Premises Data Gateway, try restarting the gateway service. Sometimes, a simple restart can resolve connectivity issues.

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Barattolo_67]

Thanks for the reply, even if it does not help much. The credentials I have provided work fin from the desktop, which indicates that I have access to the underlying SharePoint list (which by the way I use daily in my work). The problem comes when I publish the report to the PoweerBI service.

When I publish the report, thereport publishes fine. However, after that the PowerBI service stops the automatic refresh with the above error message. In the PowerBI model there is no way to enter my user name and my password. I have already tried to clear the cached credentials. I am not using an on premise gateway.

Thank you and best regards.

[v-aatheeque]

Hi @Barattolo_67 ,
Apologies for the issue you are facing.

Make sure your SharePoint list credentials are correctly set in Power BI Service. Go to the dataset settings in Power BI Service and re-enter your credentials again.

If the issue continues, you may need to contact How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn for help. 

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @Barattolo_67 ,

Just checking in to see if you've made any progress with the information provided. If you found the guidance helpful, please click "Accept Answer" and "Yes" to the question "Was this answer helpful?"

And of course, if you have any further questions or need more assistance, feel free to reach out.

Thank you!

[v-aatheeque]

Hi @Barattolo_67 ,

we wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

If our response has addressed  your query, please accept it as a solution so that other community members can find it easily.