Existing SharePoint list connection failed

[Sakthisp87]

Hello,

While refreshing the dataset getting "DataSource.Error: Web.Contents failed to get contents", but recently nothing changed on the report. 

For testing purpose i connect the SharePoint online list using the connector 1.0 it`s working fine, but when I connect the list using 2.0 it throws the same error.

Thanks,

Sakthi

[Sakthisp87]

Hello willjoe,

The data source is not an excel file, it's a SharePoint online list. 

Moreover, it has been working for a long time and the issue suddenly happened. 

i don`t have any issue with the 1.0 connector.

[v-easonf-msft]

Hi, @Sakthisp87 

Please download and use the latest power bi desktop version.
You can also check if the solution mentioned in the following thread work for you.
DataSource.Error Web.Contents failed to get data from (500): Internal Server Error 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sakthisp87]

Hi @v-easonf-msft 

I have latest version of BI desktop (July update), even i have completely reinstalled the app, removed all connections, credentials and cleared all caches from the app but it doesn`t helps me.

Already i read that community post, but i don`t know how to remove the API version.

Thanks,

Sakthi

[v-easonf-msft]

Hi, @Sakthisp87 

Please download and use the latest power bi desktop version.
You can also check if the solution mentioned in the following thread work for you.
DataSource.Error Web.Contents failed to get data from (500): Internal Server Error 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[willjoe]

• Open your excel file that you wish to export.
• Using the menu bar, go to “Data”.
• Click on “From the web” from the menu items available.
• Type out the URL associated with your SharePoint account.
• Click load to import the data feed.
• Finally, go back to your SharePoint account and the list will be imported.

Regards,

Willjoe