DataSource Error

[JorgeAbiad]

Hello PBI Experts,

I'm creating a PBI report and the datasource is located in a Teams folder. That folder contains some excel files which will be used in the report.

I can connect to the datasource without any issues. However, when I go to the Power Query editor and select the target excel file, I always get the error below.

How can I fix this error? Do I need to go to the Sharepoint server and look for any trace of error messages there?

Please help me resolve this issue.

Thanks.

Regards,

JorgeAbiad

[Greg_Deckler]

Perhaps try using a SharePoint Folder connection?

[JorgeAbiad]

Hello @Greg_Deckler ,

Yes, I'm trying to get the data by clicking SharePoint folder. I can successsfuly create the connection. However, the error occurs when I import the Excel data. The error always says that "An existing connection was forcibly closed by the remote host".

Thanks.

Regards,

JorgeAbiad